Scheduling an Access Task 2

[funkmonsteruk]

I need to run some make table reports overnight when nobody is in my office. Is it possible either by using just VBA in access or combining this with scheduled tasks on my computer to get a make table query to run at a specified date/time?

I have some suucess doing this with other office applications but have used an auto_open routine... As the database is used buy other users i don't really want the make table query to run everytime the database is opened....

 

[jebry]

Hi!

Set up a public function to run the query you want. Do a time check first to make sure it is between 4:00am and 4:10am. You can then use the autoexec macro to run the code when the database opens. Finally, have your scheduling program open the database at the appropriate time so the code will run.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[FancyPrairie]

You can use the Windows Task Manager to schedule your database to run at a specific time. To launch the database via Windows Task Manager, in the Run box, type the following:

"c:\...\msaccess.exe" "C:\yourdatabase" /x "NameOfMacroToRun"
Note that the /x option tells Access not to run the AutoExec file upon opening, but rather open the macro you specify.

You could, within Access, create a shortcut to the macro you plan to launch and reference the shortcut in the Run Box.

 

[FancyPrairie]

In my last post I mistakenly said to use the Windows Task Manager. It should have said the Windows Task Scheduler.

 

[mp9]

Windows Task Scheduler is okay but it (arguably) compromises the security of your database, as anyone using your PC can open the Scheduler and view your database or user account passwords.

I prefer to use the Handy Access Launcher (HAL) to do the same job but without compromising database security and at the same time using less system resources than Windows Task Scheduler.

HAL can be found at either

http://www.geocities.com/waddly/accory.html

or

http://www22.brinkster.com/accessory

and is freeware.

http://www22.brinkster.com/accessory/