C
Cakeaholic
How do I schedule a macro to run daily?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom
If you are using an mdb file nothing is designed to do this. If you are
using an adp file with SQL server you can use the SQL server agent.
The way I would do it with an mdb file would be to have a form and use the
OnTimer event. Set the event to run every 5 seconds and the write some code
to control the execution of your macro. Open the form hidden when the mdb
opens. Note that the mdb obviously has to be open in order for the macro to
run.
using an adp file with SQL server you can use the SQL server agent.
The way I would do it with an mdb file would be to have a form and use the
OnTimer event. Set the event to run every 5 seconds and the write some code
to control the execution of your macro. Open the form hidden when the mdb
opens. Note that the mdb obviously has to be open in order for the macro to
run.
J
jwm
See the Event Scheduler at http://www.databasecreations.com/prod_ezext.htm
S
Steve Schapel
Cakeaholic,
You can use the Windows Task Manager for this. The Command Line for the
scheduled task will be something like this...
"C:\Program Files\... PathToAccess\Msaccess.exe"
"C:\PathToDb\MyDB.mdb" /x NameOfMacro
You can use the Windows Task Manager for this. The Command Line for the
scheduled task will be something like this...
"C:\Program Files\... PathToAccess\Msaccess.exe"
"C:\PathToDb\MyDB.mdb" /x NameOfMacro
C
Cakeaholic
Thanks Steve, that worked but there is a password for the database since it
is shared that is stopping it.
is shared that is stopping it.
S
Steve Schapel
Cakeaholic,
Sorry, as far as I know, there is no way around this apart from removing
the password from the database.
Sorry, as far as I know, there is no way around this apart from removing
the password from the database.