hi all, my vb program r connected to mdf file to allow update,view n delete of database data. the mdf file is located at the \bin folder.

the problem is whenever i run the program, it will automatic copy the mdf file from the \bin folder to \bin\Debug\bin folder.

all the update n delete is then done on the mdf file located at \bin\Debug\bin.
when i run the program again, it will copy the mdf file from \bin and overwrite the mdf file at \bin\Debug\bin.

i try to delete the mdf file at \bin folder but error saying "unable to copy mdf from \bin to \bin\Debug\bin".

anyone know any solution? thanks