Backup MS Access Database

Question

Hi Would you please give me your opinion on the following: I want to give the user the option to backup data that is save a copy of the database he is working on currently. I am using: System.IO.File.Copy(...); which just copies the database to another location. Then I would give him the option to restore which basically copies the backed up db to the original. Is that good practice? I think it's enough as a solution but are there any disadvantages please? Thanks

Andrew · Answer

Hi Hirendra I couldn't exactly understand the reasoning behind that code... But now I am taking a diff approach to solving my problem. Thanks just the same! :)

Hirendra Sisodiya · Answer

Hello Andrew you can know that someone else is using your database or not? use this code sample and test this if (System.IO. File .Exists( C:\Database.mdb )) { try { using ( FileStream fs = new FileStream ( C:\Database.mdb  FileMode .Open FileAccess .ReadWrite)) { fs.Close(); } //Database is not in use return false ; } catch ( IOException ex) { // Database in use } } thanks Please mark as answere if it helps

Andrew · Answer

Aah to avoid dirty reads etc right? Let's take the scenario that: A is updating db1 AT THE SAME TIME B restored db1 to an earlier state A saves updated version of db1 (Which produces incorrect results) In that case what should be done? How can one know is someone else is using that db? Is there any c# command which tells the user if the database is being used by someone else? Thanks in advance

Hirendra Sisodiya · Answer

hello Andrew yes you Can do it in this way there is no problembut make sure any active connection should not e present on time of database restoration or during taking backup there is need to close active connection otherwise application will give io.error. thanks Please mark as answere if it helps