Changes to database don't stick

[Nonz]

I'm developing a program using visual studio 2010 in C# and using an access 2007 database.
When I save contents to the database, I get no errors. Also when I retrieve information from the database whilst the program is running I get no issues. Problem is once I stop the application, all the data stored whilst the application was running disappears.
I've checked everything on the program but I don't seem to see anything wrong.
Please help.

[Robeen]

I'm not a C# developer but I have worked with Visual Studio - VB.Net.

From what you're describing, it seems like while your program is running all the data that you are adding is getting added to your recordset which is being held in memory - and you can see it.

It doesn't seem to me that the problem is an Access issue.

Is it possible that your Program is not committing your changes [writing it to the access database from the recordset that is in your C# program memory] before you exit your application?

[Nonz]

Only to find out it really was the dataset that wasn't saving the data. There was nothing wrong with the database. Thanks

[Robeen]

I'm glad I could be of some help!!
But - you really figured it out on your own!!

All the best!