Referencing Access 2000 Runtime Question

[Sydney1]

Hi,

I have a shortcut that is trying to open a database in Access 2000 runtime, but after the user puts in his name and password the database doesn't open, and only the Access program opens (He gets the shell of Access, with the gray background). I believe that I am improperly referencing Access within the following code

AccessPath = "C:\Program Files\Microsoft Office\Art2K\Office\msaccess.exe"

Access was put in the Art2K folder due to the runtime version not conflicting with the other Office programs.

Thanks in advance for your help.

Sydney

 

[Remou]

Hi
This is from an MSDN library:
"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\Program Files\Microsoft Office\Office\Samples\Solutions.mdb" /runtime

This runs the Solutions.mdb with runtime.

 

[Sydney1]

Hi,

Thanks for the reply and help. I currently have the following code

DBPath = """"&"\\Production\Plane \PlaneAnalysis2000.mdb"&" "&"/runtime"&" "&"/wrkgrp"&" "& """"&"\\Production\Plane \PlaneAnalysis2000.mdw"&""""

but am getting an error stating "The command line you used to start Microsoft Access contains an option that Microsoft Access doesn't recognize. Exit and restart Access using valid command-line options."

This error appeared after I put in the runtime part. Any further help would be greatly appreciated.

Thanks
Sydney

 

[Remou]

Hi
Afraid you've lost me now.