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