Is it possible to run Access Database at a pre-set time?

  • Thread starter Thread starter SP
  • Start date Start date
S

SP

Good afternoon everyone,

I am a beginner level Microsoft Access 2003 user. One of the questions
raised at my work place was, "Would it possible to automate Microsoft Access
2003 to run a particular task on a scheduled time and date of each month?"

For example, could Microsoft Access 2003 be run at 12:00 am midnight of the
last calendar day of a given month (i.e. Jan 31, Feb 28, Mar 31, Apr 30,
etc.)?

Simply put, can Access be run at a pre-scheduled time automatcially?

Thank you,
SP
 
Yes! You can use the Windows Scheduler to open an Access application at a
prescheduled time. Then you can create an autoexec macro in the application
to perform a certain task when the allication opens.

Look in Windows Help for the Windows Scheduler and Access Help for the
autoexec macro.

Steve
(e-mail address removed)
 
Yes, you can run access at set times using windows task scheduler.

Another way, probably not as advisable, but possible, would be to have your
db open on a machine and set a form's timer event to continuously check the
date/time and execute your action per your code. But like I said, Task
Scheduler is a better approach.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Back
Top