How can I turn off all secruity?

[Scott]

I am leaving my company in two weeks and all the access databases I have
built are tied to security that I enabled. It is a specific secured.mdw
file. I want to make sure that the security is turned off, giving my
replacement the chance to enable it him/her self if they choose. I hope I
have asked the right question...

Thanks!

 

[Keith Wilby]

I am leaving my company in two weeks and all the access databases I have
built are tied to security that I enabled. It is a specific secured.mdw
file. I want to make sure that the security is turned off, giving my
replacement the chance to enable it him/her self if they choose. I hope I
have asked the right question...

Thanks!

Give full permissions to the "users" group for all objects.

Keith.
www.keithwilby.com

 

[Joan Wild]

It's not something you can just enable/disable.

If you want to remove security, you'd login as the owner of the database (or
a member of Admins Group), and grant full permissions on all objects to the
Users Group.

Open Access, while joined to the standard system.mdw that ships with Access,
create a new mdb and import all the objects from your secure mdb.

That mdb is now unsecured, and you could delete the secured.mdw and the old
secured mdb, leaving your replacement to start from scratch.

A simpler alternative is to just give your replacement the username/password
for the user that owns all the objects - that will give them full control.

 

[Scott]

Thanks guys...this is exactly what I was looking for. I appreciate the help.

 

[Rick Brandt]

I am leaving my company in two weeks and all the access databases I
have built are tied to security that I enabled. It is a specific
secured.mdw file. I want to make sure that the security is turned
off, giving my replacement the chance to enable it him/her self if
they choose. I hope I have asked the right question...

Thanks!

Sign on as someone with administrator rights and grant permissions on all
objects to the Users group. Then close Access and reopen using the default
System.mdw workgroup. Create a new blank file and import into it all objects
from the orginal file. The resulting file will have zero security.

Actually step one above will let anyone open the original file, but the second
step transfers ownership of all objects to the default user Admin so it makes
the file the same as if security had never been in the picture.