Database Backup

  • Thread starter Thread starter bangaram via AccessMonster.com
  • Start date Start date
B

bangaram via AccessMonster.com

Hi,
can any body tell me how can i backup my access database while its running...
for example i want to provide an option to the end user as Databse Backup..
Using this option user can able to back up DB when ever he wants db backup...
 
bangaram said:
can any body tell me how can i backup my access database while its running...
for example i want to provide an option to the end user as Databse Backup..
Using this option user can able to back up DB when ever he wants db backup...
Click to expand...


Not a realistic objective. An open file, especially a
database, is in an unknown state so any copy will not be
reliable.
 
If all you want to do is back up your data (tables) you can use
transferdatabase thusly:
DoCmd.TransferDatabase acExport, "Microsoft Access", "Path to the backup
database", acTable, "Name of the object to be backed up", "Name of the backup
object", False
Repeat this line for each table to be backed up.
You could put this code in the OnClick of a button on an unbound form or as a
toolbar menu item.
 
Back
Top