schedule macro

[Guest]

from xp, with windows scheduler on my local and my database on a network; I
cannot get a macro to execute.(run a query and export to a text file using
"TransferText")

when I run the schedule, it opens up access but the macro does run.

I've tried "C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourDB.mdb" /x
NameOfMacro
format in the command line and just "C:\PathToDB\YourDB.mdb" /x NameOfMacro
in the command line

same results.

Any suggestions please

 

[Ken Snell [MVP]]

Did you replace
PathToAccess
with the correct path?

Did you replace
PathToDB
with the correct path?

Did you replace
YourDB.mdb
with the correct filename?

 

[Guest]

yes to all; I've tried hundreds of ways

in another forum it was suggested to use "system scheduler" from
http://www.splinterware.com/

it works from that program

 

[Ken Snell [MVP]]

Post the exact command line that you're trying to use.