Backing Up an Access 2000 Database

[Don Garry]

Hello out there !

What would the best or most efficient way to programatically backup an
Access 2000 database ?

Plus I'd like to date stamp the backed up database file if possible.

Any assistance here would be greatly appreciated.

 

[Bob]

Any backup software will do the job and the resulting
database file(s) will be date stamped. If you're setup in
a workgroup environment make sure you include your
system.mdw file too.

 

[Don Garry]

Thanks Bob, any particular backup software that you would recommend ??

 

[John Vinson]

Hello out there !

What would the best or most efficient way to programatically backup an
Access 2000 database ?

Plus I'd like to date stamp the backed up database file if possible.

Any assistance here would be greatly appreciated.

Note that you CANNOT back up a database using code within that
database, and you should never back up a database which is open - it
runs a great risk of being corrupt when you restore it.

Backups should be made using external backup software - there are
dozens of such programs on the market. Be sure the database is closed
before running the backup.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps