Macros with runtime

[Rick]

When I open my database at night, with windows scheduler
to perform some procedures I use a comand line which runs
a macro upon opening. During normal hours I open it
without running the macro.
I just tried opening with the command line from a computer
using Runtime Access and the macro did not run. Should
Runtime be able to run a macro from a command line prompt?
Or is there another way to run that macro (or the code it
actuall running) from a command line?
I don't want to run the procedure when I open the database
normally.

Thanks.

Rick

 

[Steve Schapel]

Rick,

I know of no reason why the fact of Runtime would affect the functioning
of the macro. Is your command line actually opening the database? And
I presume you are using the /x macro switch in the command line?

 

[Rick]

Steve,

It is opening the database and the start up form, but not
running the macro. Here's the command line:
"c:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
C:\CCS\CCSFront.mdb /x AutoUpdateN

Thanks.

Rick

 

[Steve Schapel]

Rick,

Hmmm. Can't think of what's happening here. What does the macro do?

According to my understanding, it would be unusual to have the Access
Runtime files in c:\Program Files\Microsoft Office\Office\.

 

[Rick]

Steve,

My bad. Just realized I did not have the "c:\Program
Files\Microsoft Office\Office\MSACCESS.EXE in the command
line. It was just C:\CCS\CCSFront.mdb /x AutoUpdateN which
was opening the db but not running the macro. When I added
c:\Program Files\Microsoft Office\ART\Office\MSACCESS.EXE
it works (I don't know why my set up program installed
MSACCESS in ART, but anyway that fixed it. Thanks.

 

[Steve Schapel]

Rick

ART means Access Run Time. That is where I would expect to find
msaccess.exe in a runtime installation.