Acc10 cannot run the /X command on Acc9 DB

R

Rob Rohrbough

I will be preparing to run some of my clients' Access 2000
databases under Access 2002. Tested the first one this
AM. Was able to open the DB OK. Manually started
the "Setup" macro OK. I do not use "AutoExec" in order to
allow alternate startup macros in the same DB using the /X
parameter in a command script.

When I try to open the DB from a batch file with the call:

start msaccess DB.mdb /x StartUp

I get the message "Could not find DB.mdb...". I then
changed the default MDB location to ".\". Now the
shortcut can find the DB, but it cannot run the macro.
Even if I run the macro manually from the DB container, I
get the message box titled, "Action Failed" with Macro
Name of "StartUp", Condition "True", Action
Name "RunCode", and Arguments "pbrAutoExec()" (my autoexec
sub). I tried renaming the "SetUp"macro back to the
AutoExec" macro. The only way that will run is to call
the DB directly from the shortcut (or open the DB
manually). If I try to call the DB from a batch file as:

start msaccess DB.mdb

Even the AutoExec macro gets the "Action Failed" dialog.
I will confess that I did not write down the original path
for the default MDB location. If anyone know what it
should be, I would appreciate that. Moreover, I would
like to know if this is expected behavior :(, or if is a
known issue that might be addressed in a Service Release.

TIA,

Rob

PS: Se my related issue, "Acc10 loses Acc9 libraries
after viewing VBA".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top