Daily automated backup/compact procedures

  • Thread starter Thread starter \karen scheu via AccessMonster.com\
  • Start date Start date
K

\karen scheu via AccessMonster.com\

I have an idea of what I have to do, but I am a bit confused as to how to
approach this correctly:

I have a BE database and a FE database. In the BE database I created a macro
to execute a function that will Transfer the updates from AS400 file to
access table and run various queries to update the master table.

What I need to do is the following:

Schedule to start at 5 AM
Backup the BE database
Run the macro that executes the daily update procedure
Compact the BE database
Close the database

I can already schedule the BE database macro to kick off and the daily
updates are running successfully, but how to I wrap this all up and include
the backup and compact stuff. I can't backup the database while I have it
open to run the macro, so how do I approach this? Any advice is much
appreciated.

Thanks
 
Use the command line interface with /x to run a macro on startup. Use a
windows script or another access database and vba code to copy your database
file. There is also a command line /compact to compact the database.
 
Back
Top