schedule a macro with /x not working

[karen scheu via AccessMonster.com]

I have a macro called test that simply runs a function called getdailyupdate()

If I run the macro manually, the function runs perfeclty. If I schedule it
to run using windows scheduler with /x "test", Access starts up and the
database window shows the modules and that's it. The function never gets
executed. Does someone know what is going on?


Thanks,
Karen

 

[Douglas J. Steele]

How are you scheduling it? I believe that the scheduling tool will open a
database if you strictly pass the name of the database. However, the command
line options apply to msaccess, the executable, not to the database itself.

You must supply the complete path to msaccess in order to use command line
options:

"C:\Program Files\Microsoft Office.11\OFFICE11\msaccess.exe" "C:\My
Data\MyDatabase.mdb" /x "test"

 

[karen via AccessMonster.com]

How are you scheduling it? I believe that the scheduling tool will open a
database if you strictly pass the name of the database. However, the command
line options apply to msaccess, the executable, not to the database itself.

You must supply the complete path to msaccess in order to use command line
options:

"C:\Program Files\Microsoft Office.11\OFFICE11\msaccess.exe" "C:\My
Data\MyDatabase.mdb" /x "test"

I have a macro called test that simply runs a function called
getdailyupdate()

[quoted text clipped - 7 lines]

Thanks,
Karen