Removing security from an access database.

[hulioman]

I have a database I created... I would like to remove the
security from it so another person can have full rights to
it. Is there a way to do this.
The security is set up through a workgroup information
file.

 

[Joan Wild]

There are steps outlined in the security FAQ to unsecure a database.
http://support.microsoft.com/?id=207793

Essentially, you login in as a member of the Admins group, give the User's
group full permissions to all objects in the database. Close Access and
reopen it using the standard system.mdw workgroup. Create a new database
and import all objects from the old.

--
Joan Wild
Microsoft Access MVP

1. Log on as member of the Admins group.
2. Add the Admin user to the Admins group.
3. Give the User's group full permissions to ALL objects in the database.
4. Change the Admin User's password to a blank.
5. Have all users join the system.mdw workgroup

6. Open Access, create a new database and import all objects from the old.