Hi Rashid,
To remove User-Level security (unsecure) on your Microsoft Access database
file perform steps similar to the following:
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.
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: "Rashid" <
[email protected]>
| Sender: "Rashid" <
[email protected]>
| Subject: can not open MDB file
| Date: Fri, 30 Jul 2004 20:34:24 -0700
| Lines: 8
| 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
| Thread-Index: AcR2r0Yyk2UzI85GQNqyFT75TcAxBA==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.security:12491
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.security
|
| I copied a MDB from one computer to other computer, but
| can not open that file because of the permission issue...
| I am really tired of this situation... I want to remove
| completely the security options.. want to remove any kind
| of permission issue... How can I do that... The Safe
| Source Code is also running on main computer, I would
| like to remove that also... Please help me...
|
|
