Schedule a function to run everyday at 4:00 A.M.

[SAC]

I have a function that imports records and I'm wondering if I can get it to
run everyday at 4:00 A.M.

Thanks.

 

[iTISTIC]

One solution would be to write a VBScript file (filename.vbs) which
handles the data import, and then schedule this VBScript file to run
using Scheduled Tasks in Win2k/XP or by using the "AT" command.

 

[SAC]

I'm sorry, I don't know what that is as far as executing code.

I've used vbScript in Web pages. Is that the same?

 

[SAC]

Is the "AT" command in windows?

 

[Van T. Dinh]

1. If you database is always open on your PC, you can simply use the Timer
Event of a Form that is always loaded in your database to activate the
Import procedure.

Check Access Help on the Timer Event.

2. If the database is not open all the time, you can use Windows Scheduled
Task to start Access with the /x argument to run a Macro or the /cmd
argument to run a procedure.

Check Access Help on "Startup Command-line options" and Windows Help on
Scheduled Task.

 

[SAC]

Excellent!

Then how do I close the db?

1. If you database is always open on your PC, you can simply use the Timer
Event of a Form that is always loaded in your database to activate the
Import procedure.

Check Access Help on the Timer Event.

2. If the database is not open all the time, you can use Windows Scheduled
Task to start Access with the /x argument to run a Macro or the /cmd
argument to run a procedure.

Check Access Help on "Startup Command-line options" and Windows Help on
Scheduled Task.

 

[iTISTIC]

You could probably close the db right in the procedure you execute.

 

[Van T. Dinh]

DoCmd.Quit as the very last action.