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

Any suggestions please
 
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.
 
Back
Top