how to create ms access backup and restore in c#

Question

hi how to create ms access backup and restore in c# i have no idea to code please tell me example as code

Kirtan Patel · Answer

Hi friend , Here is What you want dont forget to mark " Do you like answer " please it will give me some Credits :) private void btnBackUp_Click( object sender, EventArgs e) { string CurrentDatabasePath = Environment .CurrentDirectory + @"\Database3.accdb" ; FolderBrowserDialog fbd = new FolderBrowserDialog (); if (fbd.ShowDialog() == DialogResult .OK) { string PathtobackUp = fbd.SelectedPath.ToString(); File .Copy(CurrentDatabasePath,PathtobackUp+ @"\BackUp.accdb" , true ); MessageBox .Show( "Back Up SuccessFull! " ); } } private void button2_Click( object sender, EventArgs e) { string PathToRestoreDB = Environment .CurrentDirectory + @"\Database3.accdb" ; OpenFileDialog ofd = new OpenFileDialog (); if (ofd.ShowDialog() == DialogResult .OK) { string Filetorestore = ofd.FileName; // Rename Current Database to .Bak File .Move(PathToRestoreDB, PathToRestoreDB + ".bak" ); //Restore the Databse From Backup Folder File .Copy(Filetorestore, PathToRestoreDB, true ); } }

thiyagaraj · Answer

You must use "using system.io; "package to fix file error

sailu bade · Answer

add namespace for that using System.IO;

devanand yadav · Answer

Cannot create a file when that file already exists.

Thanh Nguyen · Answer

Sorry,but i have done it but it warning me that: How can i fix it?Please give me answers to sv_noivu_9x@yahoo.com Thanks!

Biswa Roy · Answer

Thanks a lot....Patel. You Saved My time and very useful solution with a very small lit of code. Can you also help me out on this: I want to create crystal report programatically, so that I can use it in my modified invoice every time.