removing security from an Access database

[Guest]

Hi there.

I've accidentally put security on an access database and need to know how to
remove it, if possible.

Can anyone out there help with this?

Thanks in advance.

Shane

 

[Arvin Meyer]

Have a look in the Access Security FAQ for the method.

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Joseph Meehan]

Hi there.

I've accidentally put security on an access database and need to know how
to
remove it, if possible.

Can anyone out there help with this?

Thanks in advance.

Shane

Do you still have personal access to the database as administrator?

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793 I believe it
will address your questions.

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing. <- Of
course it is a little late for this advice.

 

[Rick Brandt]

Hi there.

I've accidentally put security on an access database and need to know how to
remove it, if possible.

If it was accidental it is VERY likely that the security has massive holes in it
anyway. Try opening Access with the default workgroup (System.mdw) and create a
new blank database, then see if you can import all of the objects from the
original file. If you can the resulting file will be the same as one where
security was never applied.

If you cannot import the objects (permission denied) then you will need to open
the file using the workgroup file used to secure it logging in as a user with
administer authority. Then you can grant full permission to all objects to the
group "Users". After that the procedure outlined above can be tried again and
it should work.