Opening a DB command line problem

[newfrontiers]

Hello, I have just split a database and part of the login routine requires the db to close and open again. The following line is used to accomplish this:

MSAccess.exe C:\Documents and Settings\Kathy\My Documents\master_fe.mdb /cmd jpoppe

On one computer the database opens fine, but on others I am receiving an unrecognized command error. All computers are using Access 2003.

Can anyone direct me as to why this occurs?

Thanks,

John

 

[Frink]

Hallo,

Do you know which part of the command line is unrecognised?
Is it MSAccess.exe, C:\Documents and Settings\Kathy\My Documents\master_fe.mdb or jpoppe?

Is C:\Documents and Settings\Kathy\My Documents\master_fe.mdb on both computers hard drives?

Try putting C:\Documents and Settings\Kathy\My Documents\master_fe.mdb in quotes.

Also try setting an explicit path to MSAccess.exe, also in "s

Otherwise it may ba how your software uses the Command$ function.

- Frink

 

[newfrontiers]

Thank you for your reply. The quotes did it! Thanks again.