Hi Alex,
To unsecured the database (i.e., remove security) here you go:
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
--------------------
| From: "APH" <
[email protected]>
| Subject: Transfer between .mdw's
| Date: Wed, 4 Aug 2004 16:13:51 +0100
| Lines: 16
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <
[email protected]>
| Newsgroups: microsoft.public.access.security
| NNTP-Posting-Host: 82.152.16.178
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:12585
| X-Tomcat-NG: microsoft.public.access.security
|
| Hi i have just taken over a database from a colleague. I have the
| system.mdb, the data.mdb and the relevant .mdw files. Their is a password
| to access the databse, and within the database, every seems to have user
| profiles, all of which have different rights for different elements.
|
| I need to remove the security from the mdb files and attach them to
another
| new work group which has a more relaxed security policy, and where
everyone
| has rights to read write create.
|
| What is the best way to achieve this please
|
| thanks
|
| Alex
|
|
|
