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

S

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.
 
I

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.
 
S

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?
 
V

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.
 
S

SAC

Excellent!

Then how do I close the db?


Van T. Dinh said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top