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

--
Message posted via http://www.accessmonster.com

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.

""karen scheu via AccessMonster.com"" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> 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
>
> --
> Message posted via http://www.accessmonster.com