My database gets cleared upon my application startup

[Kofi Ambrose]

I am building an application in VB.Net and i am using ms access database. The problem is that when i insert data into the database, it goes alright but upon running the program again, the database loses all its data. I went to the dataset code and saw this property "ClearBeforeFill" been set to true and i changed it to false yet the problem persists. Can somebody come to my aid.

[Eslam Afifi]

ClearBeforeFill indicates the Fill method shall clear the dataset before filling it. It has nothing to do to with the database. I guess your problem is one of the following: - You don't call the Update method. - Your database gets overwritten every build. This is determined by the "Copy to Output Directory" property of the database file (select the file from the Solution Explorer, you'll find this property in the Properties Window). And let me know if this solves your problem.

Eslam Afifi

[Tom Deketelaere]

are you using Vista? it could be a problem with the rights (virtualization and such)

[Dave Kreskowiak]

Is your .MDB file part of the project?? Click on the file and check the Properties window. Does the "Copy to Output Directory" option say "Copy always"?? Change this to "Copy if newer". The database in the bin\Debug folder is getting overwritten with the original copy of the .MDB file in your project folder, thereby overwriting any changes your code makes to the Debug copy of the database.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008