How can I open an mdb using a certain workgroup?

[David]

A button on my form executes this code and it works.

stAppName =
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE " &
"\\gofs1\ats\PRD\Data\PRDr0.mdb"
Call Shell(stAppName, 1)


When I add the workgroup information it won't work.

stAppName =
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE " &
"\\gofs1\ats\PRD\Data\PRDr0.mdb" & "/wrkgrp \\gofs1\ats\PRD\Data\PRD.mdw"
Call Shell(stAppName, 1)

 

[Douglas J. Steele]

You need to ensure that there's a space between the database name and the
/wrkgrp switch.

What you've posted doesn't have such a space.