How can I open an mdb using a certain workgroup?

  • Thread starter Thread starter David
  • Start date Start date
D

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)
 
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.
 
Back
Top