Setting Up Workgroup Files for a Secured DB

  • Thread starter Thread starter Jason Buck
  • Start date Start date
J

Jason Buck

Whenever I set up one workgroup file in a specific
directory. All of my other Access DBs pick up the new
workgroup file in that directory by default. I need to be
able to assign permissons to my Users without attaching
this workgroup file to all of their Database. I have read
the help files but I still can fix this major problem.

Does anyone have any suggestions?

Thanks for the help in advance.
 
You don't mention the version, but when you set up a workgroup file, you are
'joining' it meaning it is the default one to use for all Access sessions.

You need to reverse your thinking - you don't attach a workgroup file to a
database, you attach a database to a workgroup file.

The workgroup file is used for an Access session. Once the session is
started, you could open any number of databases and you'll be authenticated
based on the workgroup file being used in that session.

What you need to do is use the workgroup administrator to join the
system.mdw workgroup that ships with Access. This one will then be used for
all sessions unless another one is specified. This workgroup file will log
you in silently as the user Admin.

For your secure database(s), you would create a desktop shortcut that
specifies a different mdw to use. This mdw will only be used for that
session (it doesn't change the default mdw). The target of the shortcut
would look like

"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
 
Back
Top