Access Database Backup
-
Hello everyone , I am trying to back up a database using VB.net . Is there any coding for that ? I need to backup a database connected to !!! Not a database that is not connected to !! Because when I open my program it will automatically connect to the database . J ,
-
Hello everyone , I am trying to back up a database using VB.net . Is there any coding for that ? I need to backup a database connected to !!! Not a database that is not connected to !! Because when I open my program it will automatically connect to the database . J ,
An Access Database is just a file... you could do a file copy to a backup location. I'm not sure that the mdb file being opened will affect this process. If it does, you could always temporarily close the connection and restore?
-
An Access Database is just a file... you could do a file copy to a backup location. I'm not sure that the mdb file being opened will affect this process. If it does, you could always temporarily close the connection and restore?
-
Hy , Thx for ur answer . But whats the code like ? Check if the file exist and the copy it to another directory on a button click ? How the code look like ?! Thx again. J ,
John Kh wrote:
Check if the file exist and the copy it to another directory on a button click
You could do something like that... that would be the easiest. Only thing is, you will need to make sure that the backup copy works. So restore the database back to original location and check that it actually has been copied over correctly.