Question A2003 Command Line options

[converse]

In Access 2000, to open a database with the correct workgroup and username/pw I used:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /wrkgrp "C:\MyApp\MyWorkgroup.mdw" "C:\MyApp\MyDatabase.mdb" /user MyUsername /pwd MyPassword

If I try this with Access 2003 (which I'm converting some systems to) it fails giving the error:

"The command line you used to start MS Office Access contains an option that MS Office Access doesn't recognize"

I've converted the workgroup file to a 2003 format, and the MDB.

If I open it manually it works fine.

Any ideas?

PS I've office 2000 installed in one location, 2003 in another, obviously I'm setting the correct loading path for Access 2003 in the shortcut.

 

[James Dudden]

Hi,
I don't know if this will fix your problem but my command line is in a slightly different order and I don't put the username and password in it as follows:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "K:\Savills\SSE\SSEFront.mdb" /wrkgrp "K:\Savills\sse\sse.mdw"

 

[converse]

Thanks James, it seems it's an issue if Access 2000 is installed then 2003 is installed also on the machine. As I've tried on another machine with just 2003 and the command line works perfectly just as in 2000, strange behaviour!

 

[James Dudden]

Just had a thought - is it because you are targetting the wrong MSACCESS.EXE in your path?

If you have 2 versions of Access installed you will probably have 2 different folders with different files inside. Try editing the command line and changing the path to the other folder.

 

[converse]

No I checked that too, in fact access 2003 opens, but before it does it gives the errors that the command line can't be used to start access etc. Yet you can open the file fine from the File>Open etc.

Works fine on 2 PCs I've tested with just Office 2003 installed, but not with one that has a full install of Office 2000 then 2003 in a separate folder.

In fact I copied the shortcut directly from the problem PC to the working ones and it loads straight away, just changing the location of Access in the shortcut.

I've made sure the SP3 hotfix was installed too...