How do you save to Access Db using C# application?

[Brian Connelly]

I have application that codes and binds an access database to a windows form application. Everything seems to work however, nothing is actually saved in the database. Updates and deletes are coded and debugging steps through, but checking the db, the data is the same.

Any ideas?

[programmher]

I found this on Stackoverflow. It might help:

Is the database in your bin directory? Is it also part of your project? I have seen this happen when every time you build it overwrites the database in your bin directory with the one from the project directory, so it appears things are not getting saved.

--- To view any and all changes to your DB via application use this one When you initially add the DB to the project, it is set to always update the product on build. This can be a good thing, but I find it rather annoying. In order to fix this: Select the MS Access DB from your Solution Explorer, Hit F4 to go to it's properties, Change the field "Copy to Output Directory" to "Copy if newer" instead of "Always".

http://stackoverflow.com/questions/5...er-execution-c

[Brian Connelly]

Thanks. I had found the same article last night too. Something so simple caused such a headache and waste of time. Thanks for responding cause this was the issue.