Problem Access /wrkgrp parameter onStartup

[babydx]

Hello.

We have problems pointing users to the workgroup security file for the Access database. The users all
have Id and passwords and can get in if they join the workgroup with manual steps but this is too much for 300+
users to follow instructions.
Putting shortcut file on network with drive letter seems to switch the stored drive letters of the shortcut so that is not working. The clients are all windows 2000.

I am trying the link below to avoid drive letters but also no good.

Is it necessary to include the Access.exe in this shortcut or perhaps some other syntax problem?

thank you for any suggestions as we are stumped but it should be simple.


"\\stsrvr01\fin\dbase1.mdb /wrkgroup "\\stsrvr01-\fin\secured.mdw"

 

[Chopstik]

Perhaps this FAQ will help: faq181-3950

------------------------------------------------------------------------------------------------------------------------
"The major difference between a thing that might go wrong and a thing that cannot possibly go wrong is that when a thing that cannot possibly go wrong goes wrong it usually turns out to be impossible to get at or repair."
--Dou

 

[babydx]

ChopStick,
Thank you for the link. But I have that document.
Using hard coded drive letters in the shortcut file will not work so i am trying to replace letters with what was shown below but no luck.

"\\stsrvr01\fin\dbase1.mdb" /wrkgroup "\\stsrvr01-\fin\secured.mdw"

Maybe the access.exe must also be inclded ("C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" ).
but I am told that also didn't work to open the workgroup file.

 

[psemianonymous]

My FAQ isn't as useful as it looks on the surface, but the best part of it is the example. The target line of the shortcut should look like:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\atemp\dev\rq_fe.mdb" /wrkgrp "C:\atemp\dev\icg.mdw"

So if someone told you not to include the path to MSACCESS.EXE, they're wrong. After all, the "/wrkgrp" argument is a command-line parameter passed to the MSACCESS.EXE application. In other words, adapt the above line to your needs.

 

[babydx]

Thank you. You are right. The startup needs an EXE to pass the wrkgrp parameter to.
It works and will work with \\x:\dir\*.mdw syntax with no issue.