Software

Ask something
Discussion Locked

Access Security Problem

0 helpful
1 reply

by jrohrssen

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hey everyone!

How do I deactivate security in an Access database? I set up the security, added an admin and users, but its not really what I want to do, so I need to deactivate the security, unfortunately, the tutorial I have only tells me how to activate it, not deactivate it.

1 reply

by jdgretz

Go to Google or Microsoft and type "deactivate access security" that will take you to the following link:

http://support.microsoft.com/support/access/content/secfaq.asp

Here is the relevat part...

34. How can I "de-secure" a database?

You must have Administer permissions and/or be a member of the Admins group in the workgroup information file that helped protect the database. Grant full permissions to the Users group and the Admin user account. Put the Admin user back in the Admins group and remove the password from the Admin user. You will not be prompted for a logon ID and password once the password is removed from the Admin user. Optionally, you can also run the Security Wizard again to transfer ownership of all objects back to the Admin user, but the wizard will also remove permissions from the Users group, which you may not want.

jdg

This discussion is closed to new replies.