<div>
Easiest way to backup a access-database: Just copy the file to another location<br />
(in vb: &nbsp; &nbsp;<br />
dim strFileNameOriginal as string<br />
dim strFileNameBackup as string<br />
strFileNameOriginal = &quot;c:\YourPath\YourDatabase.<wbr />mdb&quot;<br />
strFileNameBackup = &quot;c:\Backup\YourDatabase.md<wbr />b&quot;<br />
<br />
FileCopy strFileNameOriginal, strFileNameBackup<br />
<br />
Otherwise, you can take a look at:<br />
With the help of this tool you can take backup of your MS-Access files and also restore the files.<br />
With Auto backup facility and more. Try it.<br />
<a href="http://www.a1vbcode.com/download.asp?ID=3252" rel="ugc">http://www.a1vbcode.com/download.asp?ID=3252</a>
</div>


Easiest way to backup a access-database: Just copy the file to another location
(in vb:    
dim strFileNameOriginal as string
dim strFileNameBackup as string
strFileNameOriginal = "c:\YourPath\YourDatabase.mdb"
strFileNameBackup = "c:\Backup\YourDatabase.mdb"

FileCopy strFileNameOriginal, strFileNameBackup

Otherwise, you can take a look at:
With the help of this tool you can take backup of your MS-Access files and also restore the files.
With Auto backup facility and more. Try it.
http://www.a1vbcode.com/download.asp?ID=3252 [http://www.a1vbcode.com/download.asp?ID=3252]

<div>
Hi,<br />
&nbsp; &nbsp; &nbsp; &nbsp; This one is not working..<br />
<br />
jaisu_krish
</div>


Hi,
        This one is not working..

jaisu_krish

<div>
What's not working ? Are you using vb or vba ?<br />

</div>


What's not working ? Are you using vb or vba ?


<div>
Through VBA:<br />
Private Sub Backup()<br />
<br />
Dim Fs As Object<br />
Dim a<br />
Set Fs = CreateObject(&quot;Scripting.Fi<wbr />leSystemOb<wbr />ject&quot;)<br />
a = Fs.CopyFile(&quot;c:\the path to yourDB.mdb&quot;, &quot;c:\the path to backup file.mdb&quot;, True)<br />
&nbsp; &nbsp; <br />
End Sub<br />

</div>


Through VBA:
Private Sub Backup()

Dim Fs As Object
Dim a
Set Fs = CreateObject("Scripting.FileSystemObject")
a = Fs.CopyFile("c:\the path to yourDB.mdb", "c:\the path to backup file.mdb", True)
   
End Sub


<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp; &nbsp; &nbsp; &nbsp; I want to take backup of Access database using VB.Is it possible?If yes, tell me how?<br />
<br />
jaisu_krish
</div>
</div>


Hi,
        I want to take backup of Access database using VB.Is it possible?If yes, tell me how?

jaisu_krish

Backup for Access database using VB6

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.