While it *is* possible to use multiple MDW files, you should (IMHO)
have a compelling reason to do so. Managing your user accounts and
groups though a single MDW is easier.
In truth, the MDW is completely separate from the database. The MDW
stores the users, groups, and passwords, while the database stores the
permissions for each account. You can open any number of databases
from a single MDW providing that the appropriate accounts exist in the
MDW file.
I recommend that you create a single, secured MDW file on a network
share (named something *other* than system.mdw) then "join" the
original system.mdw file. You launch Access with a shortcut whose
target points to the secured MDW
"fullPathToAccess.exe" /wrkgrp "fullPathToMDWFile"
See site in my signature for addtional details.
I have several Access databases in our network. All these point to one MDw
file : the System.mdw
Is it possible to create separate .MDW file fro each database? e.g. card.mdw
or Contract.mdw etc ?
Do I create these within the particular database and get the short cut to
point to the right .MDw file ?
**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
