Backup database automatically - Access 2007

  • Thread starter Thread starter Song Su
  • Start date Start date
S

Song Su

Access 2007 has a nice feature of backup database. Click Office button,
Manage, Backup. It will add date to the end of database name but before file
extension.

However, how to do this in macro? I want to backup right before my scheduled
action query to import from txt file daily at mid-night just in case
something goes wrong.

Or, can someone come up with a DOS batch file just COPY with system date
inserted between file name and extension?
 
Back
Top