Hi,
If using Access 2002 and 2003 it's included in the program see the menu
option
- Tools > Security > Workgroup Administrator
If using Access 2000 the file "wrkgadm.exe" should be located in the folder
c:\program files\microsoft office\office\1033
For 2000 version if the WorkGroup Administrator file is not loaded on your
machine then reinstall Microsoft Office.
As far as your *.MDW file do a search for all *.MDW files.
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
--------------------
| Thread-Topic: Unsecuring Tables/Forms/File and Logging on as
Administrator?
| thread-index: AcQc3SqCboM00SkeSnCTO/ATQRPX7A==
| X-Tomcat-NG: microsoft.public.access.security
| From: =?Utf-8?B?U3RlcGhhbmll?= <
[email protected]>
| References: <
[email protected]>
<
[email protected]>
| Subject: RE: Unsecuring Tables/Forms/File and Logging on as Administrator?
| Date: Wed, 7 Apr 2004 13:16:09 -0700
| Lines: 152
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:9791
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.security
|
| Eric,
Thank you so much for replying to my message. I have one more very basic
(and stupid) question to ask though: how do I join the workgroup
information file? I haven't even been able to find the wrkgadm.exe file on
my computer. I've searched and searched.
Am I looking for 'Customer Contract Revision.mdw?' (Customer Contract
Revision is the name of the file)?
This is my first Access project and I am afraid I know just enough to be
dangerous. Again - thank you THANK YOU for your assistance.
----- Eric Butts [MSFT] wrote: -----
Hi,
Here are the steps to unsecure a Microsoft Access database:
1. Join the workgroup information file (*.mdw) using Workgroup
Administrator
that defines security for the database that is secured.
2. Open the database you wish to unsecure using the logon that defines
Admin
privileges for the database (not necessarily Admin).
3. Grant full permissions to the Users group and the Admin user
account for
all
objects in the database. Change the owner of all objects in the
database
to
be the Admin user.
4. Quit Microsoft Access
5. Start Microsoft Access and open the secured database you wish to
unsecure
using the Admin logon user name.
6. Create a new, blank database named UnsecureStep1.mdb.
7. Select Tools --> Security --> User and Group Permissions from the
menu.
8. On the Permissions tab, select Database from the Object Type
combo-box.
9. On the Permissions tab confirm that the Admin user and Users group
have
full
permissions (Administer) on the <Current Database> Object Name.
10. On the Permissions tab, select Table from the Object Type
combo-box.
11. On the Permissions tab confirm that the Admin user and Users group
have
full permissions on the <New Object> Object Name.
12. Repeat Steps 10 and 11 for each Object Type: Query, Form, Report,
Macro
13. Select the Change Owner tab.
14. Select Database from the Object Type combo-box and confirm that
Admin is
the Current Owner of the database and click OK. If not, close the
database
and start fresh at Step 1.
15. Select File --> Get External Data --> Import from the menu.
16. Browse to the secured database and import all of the objects into
the
blank
database.At this point, you will have a database that is currently in
an
unsecured state
(UnsecureStep1.mdb) but still associated with the workgroup
information
file
that defines security for all databases.
17. Quit Microsoft Access
18. Start Microsoft Access.
19. Join or create a default workgroup information file using Workgroup
Administrator (wrkgadm.exe).
20. Create a new, blank database named UnsecureStep2.mdb.
21. Select File --> Get External Data --> Import from the menu.
22. Browse to the UnsecureStep1.mdb database and import all of the
objects
into
the blank database.You now have a database that is unsecured and
associated
with a default
workgroup information file (UnsecureStep2.mdb).
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
--------------------
| Thread-Topic: Unsecuring Tables/Forms/File and Logging on as
Administrator?
| thread-index: AcQczRj8tRVS2JEvQhKf5mTwAEUjfA==
| X-Tomcat-NG: microsoft.public.access.security
| From: =?Utf-8?B?U3RlcGhhbmll?= <
[email protected]>
| Subject: Unsecuring Tables/Forms/File and Logging on as
Administrator?
| Date: Wed, 7 Apr 2004 11:21:08 -0700
| Lines: 7
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:9781
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.security
|
| Hello,
I read the message from "sara" about undoing security altogther in
Access
2000...and I want to undo security altogether in an Access 2002
database.
I created three tables (and three forms for entering data into the
tables).
I made a copy of the file (mistake) and tried securing it. When it
didn't
work, I erased the copy and went back using the original. Well...the
original now has security! It never asks me to log in, but it has
restricted my permissions (i.e., I cannot modify, export, etc...all I
can
do is read, edit, delete) I have not been able to modify the forms at
all
and I need to.
The kicker is - I don't know how to log on as the administrator
either.
Help! I have to complete this project for my boss shortly and I
CANNOT
figure this out.
Any assistance anyone has to offer would be greatly appreciated...
|
|
