unsecuring a database?

S

sara

is it possible to undo the security altogether in access
2000?
i secured my database while testing it out but don't know
how to make it revert back to a nonsecured database.
any help appreciated, thanks.
 
R

Rick Brandt

sara said:
is it possible to undo the security altogether in access
2000?
i secured my database while testing it out but don't know
how to make it revert back to a nonsecured database.
any help appreciated, thanks.

Log in as an administrator and give full permissions to the group "Users"
on all objects including the database itself. Close Access and reopen it
using a non-secure MDW file. Create a new blank file and import all
objects from the original file. You should now have a file identical to
the original and as if security was never applied to it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top