Workgroup query (1 Viewer)

[moose]

If i have an .mdb that is reliant on a security workgroup, can i have another .mdb that relies on the ms default workgroup running at the same time?
If so, how do i go about doing it please?

 

[ghudson]

Yes.

The users must open the secured db with a custom shortcut that provides the target info as to where the msaccess.exe file is located, where the workgroup file is located and where the db file is located. Here is a sample as to how the target field of your shortcut should look...

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /runtime /wrkgrp "X:\YourWorkgroupFile.mdw" "Z:\YouDatabaseFile.mdb" /user YourUserName

That is all on one line with a single space between each section.

Search the Access help files for more "Command Line Options".