Help with security groups

  • Thread starter Thread starter Joe Champion
  • Start date Start date
J

Joe Champion

(e-mail address removed)

Can anyone help me to correct an error. I messed around
with adding users groups to an existing application and
set passwords where necessary. Now I am unable to even
open the application as the administrator let alone a user.

Is there a simply way to remove security?

Please email me with any suggestions at the following

(e-mail address removed)

Thanks
 
Hi Joe,

There's not a simple way. Here's what you do to remove security:

1. Join the workgroup information file (*.mdw) using Workgroup Administrator
(wrkgadm.exe) 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. Join or create a default workgroup information file using Workgroup
Administrator (wrkgadm.exe).
19. Start Microsoft Access.
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


--------------------
| Content-Class: urn:content-classes:message
| From: "Joe Champion" <[email protected]>
| Sender: "Joe Champion" <[email protected]>
| Subject: Help with security groups
| Date: Wed, 17 Mar 2004 06:43:37 -0800
| Lines: 16
| 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: AcQMLjsf7Yx3lLkxTKCgbkg7vtDMTw==
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:9201
| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| X-Tomcat-NG: microsoft.public.access.security
|
|
| (e-mail address removed)
|
| Can anyone help me to correct an error. I messed around
| with adding users groups to an existing application and
| set passwords where necessary. Now I am unable to even
| open the application as the administrator let alone a user.
|
| Is there a simply way to remove security?
|
| Please email me with any suggestions at the following
|
| (e-mail address removed)
|
| Thanks
|
|
 
Back
Top