how to create ms access backup and restore in c#

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);
 
            }
        }

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

thiyagaraj11y ago
You must use "using system.io; "package to fix file error
0
sailu bade11y ago
add namespace for that using System.IO;
0
devanand yadav12y ago
Cannot create a file when that file already exists.
0
Thanh Nguyen12y ago
Sorry,but i have done it but it warning me that:
How can i fix it?Please give me answers to [email protected]
Thanks!
0
Biswa Roy14y ago
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.
0
Kirtan Patel17y ago
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);

            }
        }
+5