Backup database automatically - Access 2007

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top