Executing a Macro from a script

[GailV]

I am using a script (.bat) to run msaccess.exe which in tern runs a macro.
My server has Microsoft Access 2003 installed, but the database itself is
version 2000. I have a 3rd party scheduling software running the script. So
far, I have not been able to run the macro successfully. The script either
runs to completion according to the scheduling software, but does not run the
macro or it runs continuously and does nothing. I can manually run the
script with success.
The command in the script is: "C:\Program Files\Microsoft
Office\OFFICE11\MSACCESS.EXE" "\\filesrvr\public\LOGISTIC\EDI Files\edi
freight.mdb" /x "mFreight bills process"
We have other scripts that run macros successfully on other servers from the
3rd party scheduling software, but the Microsoft Access installed is the 2000
version. What do I need to change to get this to work?

 

[Steve Schapel]

Gail,

Is Access 2003 installed on the local machine, as implied by the command
line you are using?

 

[GailV]

Steve: Yes, it is intalled on the local machine which is a vertual server.
GailV

 

[Steve Schapel]

I'm sorry, Gail, I don't know. But it sounds like the third party
scheduler might need tweaking, as to how they require the command line
entered. Still, I can't immediately see what difference it makes as to
the Access version. Do the scheduler's manufacturers have a support desk?