Compiling erases DATA in Access DATABASE ?

Johnkokk

Ok here is the issue. I make an application, that the user can store various data in a MS ACCESS DATABASE. I make all the connections, etc. and everything works ok. So i test run my application.I insert data to the database through my program.Everything works ok. I want to fix a bug.I correct the program and re run the app. The database is empty now and i have to re-enter the data. Even the slightest change in the program code, deletes the data from the database. Is this normal ? Thanks

Luc Pattyn

Johnkokk wrote:

Is this normal ?

No, unless you included code to that effect. :confused:

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Johnkokk

Note that when i test run my app, i do it through the IDE. Here are the steps, so that you can understand better. 1.Write some VB. net code. 2.Run through IDE 3.Insert data to database through my app 4.Find a bug 5.Stop the execution 6.Correct the bug 7.Re run the app through the IDE Data that i inserted on step 3, are deleted and Database is empty. If i open the database with MS ACCESS, fill some data there and run it from my app, everything is OK.

Henry Minute

In Solution Explorer Window click your database file node (the one with the little golden cylinder icon) then hit F4. Is 'Copy To Output Directory' set to 'Copy Always' (I think this is the default). If so, change it to 'Copy if Newer' or 'Never' once you understand what they mean. I have been caught by this when I first started. What happens by default is that each time you run the app VS copies your empty database to your output directory, overwriting your nice data filled one. 'Copy if Newer' only does so if you change the DB in some way, so you need to take steps to protect the data you have entered.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

Luc Pattyn

That makes perfect sense. Putting data files in a Visual Studio folder is something I like to avoid. :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Henry Minute

Yep. Unfortunately, a couple of the MSDN HOWTO:s/WALKTHROUGH:s tell you to do it that way. Project|Add Item|Database......... It usually mentions (or links to a page that does) the 'Copy Always' problem but it is well hidden.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

Johnkokk

Yeap, that was it.The "Copy always" thing. I knew it was not "normal". Thanks people.