Not prompting for a password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a mdb that I have added security to. I then converted it to a mde.
When I log on to my computer it prompts for security (log on and password).
I installed the files on my c: drive. Now if someone else logs on to the
computer they can open the file without entering their log on and password.
Can anyone tell me why this is?

Thanks in advance...Jennifer
 
2 things:

1. If they are not being prompted for a user name and password, then that
means that the .mdw file they are connected to is different from the one you
used to "secure" the database.

2. If they can open the database under those circumstances, then your
database is not really secure.

You should get a copy of the Security FAQ, read it several times, and follow
it to the letter. (NOTE: Use a copy of your database because you will most
likely make more than one mistake -- something all of us have done.) There
is a copy of the Security FAQ on the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
Jennifer P said:
I have a mdb that I have added security to. I then converted it to a mde.
When I log on to my computer it prompts for security (log on and
password).
I installed the files on my c: drive. Now if someone else logs on to the
computer they can open the file without entering their log on and
password.
Can anyone tell me why this is?

Thanks in advance...Jennifer
Click to expand...

You haven't invoked user-level security correctly. You need to follow *all*
of the steps in the FAQ (link on my website along with a step-by-step
example).

Regards,
Keith.
www.keithwilby.com
 
Back
Top