User-Level Security

T

TOIB

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

Microsoft 365 Activations, Users or Devices? 0
User Level Security Enquiry 1
user level security 2
user level security 3
Secure db with one password and no user-level? 1
User and Group Security 2
mde and user level security 8
security Access 2007 0

Top