Access database is copying to Output directory . . . on its own!

[CodeNoobster]

Hi everyone

i have an extremely annoying problem, I am inserting data into an access database and now i have noticed that it is copying itself to the bin/debug folder on ts own and yet i have set "Copy to Output Directory" property to "Copy never"

But without fail, it is copied! It is making any attempted updates to the database's information invalid since its not updating at all.

This all started when i installed crystal reports and it asked me to make a duplicate of the database in order to utilize data-sets that were created for certain reports.

Does anyone have any idea why this is happening? I cannot test my application properly at all.

[iam_clint]

Well your oledb connection string should be pointing the updates and such to the correct database, the copy shouldn't matter in the output directory?

[CodeNoobster]

True clint, but I did some digging on the web, when two copies of your db exist in your application, visual studio will in some cases decide to overwrite the db that has been updated with the copy that hasn't and as a result, negates all CRUD process.

Played around with it for a bit and managed to stop the duplication process and now the app functions normally. How ever i want to see what happens when i make more crystal reports and see if the cycle starts all over again.

Thanks for your input though man.