User-Level Security

G

Guest

Hi All,

I put, or I thought I did, user-level security around my database stored on
a network shared drive using the user-level security wizard. However, I can
open the database without a userid and password and now I can't open, read,
or design any tables, queries or forms. Is there anyway to start over or
erase what I did? Also, I had the help desk here at my job give me
administrator rights on my PC but that has not solved anything. PLEASE
HELP!!!!
 
J

Joan Wild

What version of Access? 2002/3 does a decent job, but not earlier versions.

It sounds like it's partially secured. The wizard creates a backup of the mdb before it secures it. See if you can find that. It'll have the same name as the mdb but a bak extension. Just rename it to have a mdb extension

Rename all the *.mdw files you can find on your computer. and start over. See www.jmwild.com/AccessSecurity.htm for a set of steps to follow.
 

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

Similar Threads

user level security 1
User Level Security Enquiry 1
user level security 1
User Level Security Malfunction 17
User level security 1
mappoint cant open access query with user level security 3
Setting up User Level Security to my Access 2003 database 1
User-Level Security Wizard 2

Top