Not prompting for a password

[Jennifer P]

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

 

[Lynn Trapp]

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

 

[Keith]

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

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