• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 725
  • Last Modified:

Workgroup shortcuts

This is a follow up question to whether or not placing a secured database on a network would interfere.  dds110 (thank you) suggested placing a shortcut with specific targets.  So do I place a short cut to the secured database (making sure the workgroup file is in the same directory) and the workgroup?  Or just the secured database.  Please explain a little more.  I understand how to do shortcuts on desktops, but I'm a little confused on what needs shortcuts (database and/or workgroup).  Thanks again.
  • 2
1 Solution
What you need to do is create a shortcut to the database that references the workgroup, using Access's wrkgrp command line switch.  Right click on your shortcut, and in the line that says "Target", enter this:

"C:\path to access on your computer\msaccess.exe" "\\path to DB on network\dbname.mdb" /wrkgrp "\\path to workgroup file\wgname.mdw"

This tells Access to open your DB using that workgroup file.  The "\\" in the network file names is called UNC - it's the universal address, in case not all computers have the network server mapped to the same drive letter.
I just had a look at your last question.  To answer this question a little more clearly, think of it this way:

You're actually creating a shortcut to Access.  Your shortcut opens Access, then Access sees that you want to open a specific DB file, and also use a specific workgroup file.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now