How To Create a Back up Of An MS Access 2003 DataBase With C# 2005 ?!.

May 9 2008 1:35 PM
Hi can anyone help me with the correct C# code to create a

Hi can anyone help me with the correct C# code to create a .bak file / a backup of an ms-access 2003 dataBase ?!. I tried using the code posted here on a seperate thread but I get the exception saying ;
 Invalid SQL Statement;expected 'DELETE','INSERT','PROCEDURE','SELECT' or 'UPDATE'

The Following is the Code I've Used To backup the DataBase.



//Event Calling the DataBase Backup Method
 private void bkUpDB_Click(object sender, EventArgs e)
        {
            try
            {
               //Calling the Method Backing Up the DataBase
                this.createBackup();
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error Backing Up the DataBase");
            }
        }


//Method Backing Up the DataBase
 public  void createBackup()
        {
             //The Current DataBase Connection String
            string conStr = "Provider = Microsoft.jet.oledb.4.0;Data Source =C:\...\Inventory.mdb;User Id=Admin;Jet OLEDB : Database Password=123123";

            //The  Path of the Current DataBase
            string dbCurrentPath = "C\...\Inventory.mdb";

            //Passing the Connection String To the OledbConnector
            OleDbConnection con = new OleDbConnection(conStr);
           
            //The Query Used To Create the database Backup
            string oQuery = "Backup database " + dbCurrentPath + " To disk="F:\...\Inventory.bak";


            OleDbCommand com = new OleDbCommand(oQuery, con);
            con.Open();
            try
            {
                com.ExecuteNonQuery();
                con.Close();
                com = null;
                oQuery = "";
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, "Error Backing Up the DataBase", MessageBoxButtons.OK, MessageBoxIcon.Error);
                con.Close();
                com = null;
                oQuery = "";
            }
           
        }


-- Please Help This is very very urgent !!.
Thanks In advance !!.



M.Shehan Ramesh Perera


Answers (3)