Remove security from mdb file

[Guest]

How does one "unrestrict" permissions or grant unlimited access to a mdb file that has embedded permissions now

thanks

 

[Joan Wild]

You login to the database as a user that's a member of the Admins Group.
Give full permissions to all objects (don't forget the database object) to
the Users Group.

Close Access. Ensure you are joined to the standard system.mdw workgroup
and open Access again. Create a new database (you shouldn't be prompted for
a username/password), and import all objects from your secure database.

The new database is unsecured.

--
Joan Wild
Microsoft Access MVP

How does one "unrestrict" permissions or grant unlimited access to a mdb

file that has embedded permissions now?

 

[Joan Wild]

The listbox in the security permissions dialog is multi-select - click on
the first one and shift-click on the last.

You have to do each object type, but there's only 7.