Schedule Access tasks

[agibsonsw]

Hello. Access 2003.
How would you approach scheduling of tasks in Access?
I was considering using Windows Task Scheduler to open a database
that contains an AutoExec macro or an opening procedure on a StartUp form?

Although I think the question is more complicated as I believe the users want
to do something on the arrival of files from Lotus Notes - if you have any hints about
that?

Thanks, Andy,

[HansV]

I can't help you with the Lotus Notes question - if you don't get an answer in this thread you might post a question about it in the Other E-mail Clients forum.

If you go for the Windows Task Scheduler option, you can also open a database and run a specific macro (instead of relying on an AutoExec macro which would run every time you opened the database). To do so, use a command line like this:

"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "\\server\share\folder\MyDatabase.mdb" /x MyMacro

Another option would be to keep the database open all the time, and to keep a form in the database open all the time, with an On Timer event that runs the code that you want.

[agibsonsw]

Thanks very much. Andy.