Removing user level security

[pat_nospam]

Just curious - I have all the passwords, etc for my workgroup, but at some point I will need to remove the user level security from the database so it can open will full access to everyone (no user/password login)

What is the easiest method to doing this?

Im running Windows XP and Access 2002

Thanks in advance,

Pat

 

[Pat Hartman]

Here's the relevant passage from the Security FAQ.

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.


However, I strongly suggest that you download the entire document and study it. You can find it by searching the Microsoft knowledge base or msdn library.

 

[pat_nospam]

Found it, thanks for the heads up - it's a treasure trove of security info.

I'm assuming that the document applies to Access 2002 also, even though it's creation date was in 2000.

Thanks again - Pat

 

[Pat Hartman]

I don't think security has changed much but I think I've seen an article that references 2002 so you might want to do a more thorough search.