backup and restore MSAccess in vb

[Bindurajan]

How do i backup and restore MS Access Database with Visual Basic

[willakawill]

How do i backup and restore MS Access Database with Visual Basic

Copy and paste the .mdb file

[Bindurajan]

actually my need is to restore data of older mdbfile to new mdb.new mdb has
some additonal fields and data.so additonal changes have to retain after restoring data of the older mdb file.

[willakawill]

actually my need is to restore data of older mdbfile to new mdb.new mdb has
some additonal fields and data.so additonal changes have to retain after restoring data of the older mdb file.

Aha. So you are not restoring you are importing the data from one mdb file to another.

[Bindurajan]

Aha. So you are not restoring you are importing the data from one mdb file to another.

Can you tell a medthod to import mdb files using vb

[willakawill]

Can you tell a medthod to import mdb files using vb

There are a few. If you do not have Access and want to do this through VB here is one method

Do While Not rsOldDB.EOF
rsNewDB.AddNew
rsNewDB("Column1") = rsOldDB("Column1")
rsNewDB("Column2") = rsOldDB("Column2")
...
rsNewDB.Update
rsOldDB.MoveNext
Loop

[amitvermaa]

Can you tell a medthod to import mdb files using vb

yes i want to know that how to create bakup in vb software with ms access