I'm working on a Windows Forms application that has connection with an Access database. I need to create a backup for that database. Also, user has to choose the destination folder of the backup. Can someone give me a help on this?
Thanks
-
Add some code to your question indicating what you have tried.J0e3gan– J0e3gan2013-05-13 06:28:37 +00:00Commented May 13, 2013 at 6:28
Add a comment
|
1 Answer
You can use option of simply copying your access DB file to another location as a backup.
It can be done as follows:
File.Copy(sourceDbName, destDbName, true);
OR
You can add a simple routine that takes your input database, zip and store it, in your backup directory, optionally passing a password, like this:
using Ionic.Zip;
......
private void BackupToZip(string sourceDBName, string destZipFile, string password)
{
using (ZipFile zipF = new ZipFile(destZipFile))
{
if (bkpPass.Length > 0) zip.Password = password;
ZipEntry ze = zip.UpdateFile(sourceDbName, string.Empty);
ze.Comment = "Working copy stored in date: " + DateTime.Today.ToShortDateString();
zipF.Comment = "This zip archive has been created by ......";
zipF.Save();
}
}
Can Refer Following link for more snipets:
