Dave said:
Using the MS-Access Workgroup Information Files, is it
possible to set up different secuirty file for each of the
databases on out system?
Yes. But you may want to set up one mdw, with all the groups/users
necessary for all databases. Then you can apply the permissions as needed
in each mdb.
It seems that as soon as I've applied one set of secuity
setting to one database they instantly apply to all
databases.
Security is session based in Access. Every time you open Access you are
using security. It ships with a workgroup named system.mdw and uses this
workgroup (silently logging you in as a user named Admin).
When you implement security, you create a new mdw file and secure your
database. Usually the workgroup administrator will make this new mdw your
default one. That is why every session of Access is now asking you for
username/password - you are joined by default to this new workgroup.
Just rejoin the standard system.mdw workgroup using the workgroup
administrator.
For your secure mdb, create a desktop shortcut that points to your secure
mdw. It will only apply for that session of Access. The target would have
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
