removing security from an Access database

S

Shane Williams

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
 
R

Rick Brandt

Shane Williams said:
Hi there.

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

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.
 
Top