Hi Doug,
The following should help explain quickly how the WorkGroup Information
File works:
- Say you created the WorkGroup Information Files
+ MyDefault.MDW
+ MySpecific.MDW
- If you are using Microsoft Access 2002 or 2003
+ within Access click the menu option Tools > Security > WorkGroup
Administrator
+ you will see what *.MDW Microsoft Access defaults to
- If you have Microsoft Access 2000 or 97 you will have to locate the file
"wrkgadm.exe" and double click it. It will show you the same information
as you would see with Access 2002 & 2003 (i.e., what's the default *.MDW
file)
- Now let's say that the default is "MySpecific.MDW". You go ahead and
create User Level Security, take away permissions for the Admin account,
etc... on your database
- A month later you change the default (you can do this in the WorkGroup
Administrator by clicking the Join button) to "MyDefault.MDW"
- You open your secured database and Access sees that you are NOT using the
WorkGroup File "MySpecific.mdw" that you used to secure the database,
thereby it brings you into the database as a guest which uses the "Admin"
account. But remember you removed permissions from the Admin account.
- You go back through the steps of launching the WorkGroup Administrator to
re-join the workgroup file "MySpecific.mdw" and now you can open your
database with the correct User account and password
DILENMA: How can you avoid from joining, rejoining, and joining back and
forth to the different workgroup files (*.mdw)?
SOLUTION: Using the WorkGroup Administrator make sure Microsoft Access is
defaulting to the workgroup file "MyDefault.MDW". Then create a shortcut
on your desktop that has the following path
"C:\<full path to MsAccess.exe>" "<full path to your MDB file>" /wrkgrp
"<full path to MySpecific.mdw"
So now when you launch Microsoft Access via the Start menu you are
defaulting to "MyDefault.mdw". And when you launch the shortcut on your
desktop your are defaulting to "MySpecific.mdw"
For detail information on the above see:
Understanding the role of workgroup information files in Access security
(305542)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;305542
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| Content-Class: urn:content-classes:message
| From: "Chaplain Doug" <
[email protected]>
| Sender: "Chaplain Doug" <
[email protected]>
| Subject: Workgroups Question
| Date: Mon, 26 Jul 2004 13:07:43 -0700
| Lines: 6
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| thread-index: AcRzTDZQNrxbROPfQPa8j5zK57kzhg==
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:12378
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.security
|
| I have only one on which database I want user-level
| security. May I set the workgroup file for this database
| only? At present it appears that when I set the workgroup
| for a database, the same workgroup is set for all
| databases. How may I set it individually? Thanks for the
| help.
|
