Macros with runtime

  • Thread starter Thread starter Rick
  • Start date Start date
R

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
 
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?
 
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
 
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\.
 
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.
 
Rick

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