How do I remove security from an Access database?

S

Sarah B

I have an Access database that has security set on it. I need to remove the
security so that I do not have to log into it.
 
J

Joan Wild

Log in as a user that's a member of the Admins Group.

Give full permission to all objects (don't forget the database object) to
the Users Group.

Go into Tools, Security, Workgroup Administrator, and ensure that you join
the standard system.mdw that ships with Access.

Close Access, and then reopen it. Create a new database and import all
objects from your secure database. This new mdb is unsecured.
 
S

Sarah B

THANKS! that did it.

Joan Wild said:
Log in as a user that's a member of the Admins Group.

Give full permission to all objects (don't forget the database object) to
the Users Group.

Go into Tools, Security, Workgroup Administrator, and ensure that you join
the standard system.mdw that ships with Access.

Close Access, and then reopen it. Create a new database and import all
objects from your secure database. This new mdb is unsecured.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Proposal template with removable sections 0
How to remove external organization from Office. 0
Remove Access Security 1
Access 2003 Security 2
Removing a repeated words 0
Security - Am I missing something? 4

Top