Security Settings

T

Theresa

I designed a database and added users but I didn't give myself Admin settings
so I can't get in the database. How can I change my Admin settings?
 
J

Joan Wild

What version of Access? Did you just start adding users, or did you run the
security wizard?
 
J

Joan Wild

Check in the folder where the mdb is located and see if there is a file with
the same name but a bak extension. This file is a backup of your mdb before
security was applied.

The wizard in 2000 is flawed and shouldn't be used. If you want to secure
it properly, restore the backup (just rename the file to have a mdb
extension). Use Start, Run, wrkgadm.exe and click on Join and rejoin the
system.mdw that ships with Access. Do a search first, to locate the
system.mdw.

Follow the detailed steps at http://www.jmwild.com/security97.htm to secure
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