Remove security from mdb file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

thanks
 
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

krcmd said:
How does one "unrestrict" permissions or grant unlimited access to a mdb
file that has embedded permissions now?
 
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.
 
Back
Top