ACCESS97

Topic

New Reply

i am trying to figure out how to execute an Access macro at the same time every morning. i thought Outlook might be the obvious choice. Can anyone tell me how this might work with Outlook or any other desktop utility?
Thanks

——————
mike

Reply | Quote

Replies

Hi Mike,

Here’s a thought: You could use the Scheduled Tasks feature built into Windows 9x (and NT, I presume). Just set an automated task to launch Access at the specified time each desired (weekday) morning. Then include the path to the access database in the command line:
C:Program FilesMicrosoft OfficeOfficeMSAccess.exe C:My DocumentsMyDatabase.MDB

Then just make sure you have the macro set to launch when the database is opened (Autoexec macro).This would not require Outlook to be open and shouldn’t require any user intervention.

Good luck!

-MarkJ-

Reply | Quote

Once again MARKJ has come through!

Reply | Quote

I’ve never tried this command line switch, but according to the online help (ask for help on command-line options) /x macroname will start a specified macro when Access starts up. So, you could use that to run your macro only when the scheduled task launches and not every time you run the database (as would be the case for the Autoexec macro).

Reply | Quote

I do exactly what Doug Martin is suggesting to run daily maintenance on a large database. I just built a simple batch file ([filename].bat)that can be run by simply double clicking from explorer, or scheduled in any application that uses a “run application” function. I used the Norton Program Scheduler that comes with Norton Antivirus for quite a while, with the path to the *.bat file and the “x/ (macroname) argument at the end. You could do it directly by supplying the path to the database too.

Reply | Quote