Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use of Shortcuts for Multiple DB Workgroups

Status
Not open for further replies.

tcosmas

Technical User
Jul 7, 2004
2
US
We are in a transitional stage between a legacy Access97 and Access 2003 version rollout. In order to view each version, the user has to switch between Workgroups. After doing this by hand, I just found that you can set up a link to the individual databases which will automate the Workgroup Join... function.

The Target would be as follows:

psuedocode
"access_location" "db_location" /Wrkgrp "wrkgp_location"

Example
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "X:\pspdb97\pspdb97.mdf" /Wrkgrp "X:\pspdb97\pspusers97.mdw"

This seems to work quite well. An advantage is that you do not have to walk your users through joinng the group when you finish the upgrade to the new version or to run various dbs with associated Workgroups under either version of Access. You would just create a shortcut with the revised Target info for each db.

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top