Backup of an Access Database

[jeva39]

I use an Access Database. In VB.NET, within the application (with a Button or Menu Option) how I can to make a Backup of the .MDB file in a specific Backup directory?

Thanks!

 

[jmcilhinney]

I just use File.Copy().

 

[jeva39]

Thanks for your help. Problem solved. If somebody need the complete code,this is an example. Works fine!!

Need two Buttons or Two Menu Options, a TextBox for the name of directory and a OpenFileDialog control:

Imports System.IO
................................

Private Sub mnuCrearDir_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles mnuCrearDir.Click
	Try
	  Directory.CreateDirectory(TextBox1.Text)
	  'Creating a directory by specifying a path in the TextBox, of the form c:\examples
	  'Instead of using a TextBox you can directly type the location of the directory like this
	  'Directory.CreateDirectory("c:\examples")
	  MsgBox("Directory created OK!")
	Catch
	  ....................
	End Try
	
  End Sub

Private Sub mnuCopiarArchivo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles mnuCopiarArchivo.Click
	Try
	  If OpenFileDialog1.ShowDialog <> DialogResult.Cancel Then
		File.Copy(OpenFileDialog1.FileName, TextBox1.Text & "\" & _
		OpenFileDialog1.FileName.Substring(OpenFileDialog1.FileName.LastIndexOf("\")))
		'The above line of code uses OpenFileDialog control to open a dialog box where you
		'can select a file to copy into the newly created directory
	  End If
	  MsgBox("File Copied Successfully")
	Catch
	 ......................
	End Try
	
  End Sub

 

[jmcilhinney]

You may like to use the FolderBrowserDialog to select the folder to save to. This rules out any invalid input in a TextBox.

 

[jeva39]

Thanks again. I try and really is a better way....

 

[kulrom]

Did you ever think about expanding this and use winZip for the backup?
Zipped file is less then original file ... that refers to size ... plus security
Cheers