Hair pulling

I finally just figured out why my database wasn’t updating.  Such a simple matter really, but it wasn’t easy to find through Google so I am posting here, mainly as a future reminder.

I am writing a small app to use as a podcast listener.  Since I don’t own an iPod, I listen to podcasts throughout the day.  Well I was at the point that I wanted to start adding data to the database.  But no matter what I tried, the data wasn’t updated.  It was getting very frustrating.  What I finally figured out was VB was copying the database to the debug directory each time.  A simple setting on the SQL Server Express properties, changing the Copy to output from Always to Copy if newer fixed it.

Hopefully this will save you some time in the future.