schedule macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
 
Back
Top