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, macro does not run.

Any suggestions please

 

[Guest]

Is this the only thing your database does? If you want a macro to run when a
database is opened, that means that even if a user opens the database that
macro will still run. If the database servers another purpose, you may want
to think about creating a separate database and linking all the tables
together and importing all the queries, forms, and macros into the new
database. But to answer your question...if you save a Macro as "AutoExec"
(not case sensitive), that macro will run upon the opening of that database.
All your scheduler has to do then is open the database. Hope that helps.