user access problem

[Guest]

I created a database on a server and have it secured so that each user has to
login with a password. The problem is it only asks me to login and just lets
everybody else in with out prompting them for a username and password.
Does anybody no why?

 

[Lynn Trapp]

First, the fact that they can get in without a username/password means you
didn't secure the database correctly. See the Security FAQ. There is a link
to it on my website. Second, the reason they are not being prompted for a
password is that they are being authenticated through a different .mdw file
than you are. Again, read the Security FAQ and see where you missed things.

 

[Guest]

Then why is it prompting me for the password. It also lets me login with
their name and password, but it only asks for it on my computer.

 

[Lynn Trapp]

Because you are being authenticated by the .mdw file that you created when
you secured the database and the password for the Admin user in that file is
not blank. The other users are probably authenticating through the default
..mdw file in which the Admin password is blank. When the Admin password is
blank Access tries to log the user in "silently."