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
ebutts@online.microsoft.com
"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

--------------------

With all do respect security that has been placed against a database and
Safe Source that has been implemented has been implemented for a reason.
How do we know you are not trying to circumvent this security to get to data
you do not have authorization too? If you are legitimate to the company who
placed the security on the database in the first place, then you should
already know how to apply security measures to a new computer to get to the
database properly. If the developer has since left the company, then perhaps
he/she can be contacted to get the proper logon information. If the
developer left under 'bad' circumstances he/she may not be willing to help.

You can try searching Microsoft Knowledge Base on how to unsecure a secure
database. However, this may not work against Safe Source settings.