Chris Connolly said:
Question: One of the users of our Access 2000 network
database is no longer being prompted to enter her
password. Instead the database just opens for her without
password prompting. This appears to be specific to her
computer as other computers in the lab prompt for
passwords and will accept her password. Any ideas?
Access only prompts for a password when the user is running Access with a
workgroup file (mdw) that has a password applied to the default user
"Admin". Normally when you secure an Access app you do so by creating it
with a workgroup file that has a password applied to the admin user (you
obviously did this). However; the user can change the mdw file that they
are using at any time. They can specify a different mdw file as a
command-line argument when opening Access and/or they can use the workgroup
administrator utility to change the default mdw file that Access will use.
The user that is not getting prompted likely has a different mdw file as
her default and the one she is using does not have a password applied to
the Admin user (so she is not prompted).
Here's the kicker. If she can use another mdw file to open your
application, then you didn't apply security properly in the first place.
When whatever happened to cause her to switch MDW files occurred, she
should have found that she could not open the file at all. She should
receive an error message along the lines of..."You don't have appropriate
permissions to open this database...".
So you need to do two things. You need to correct the problem that allows
her in with an different mdw file. After that is fixed you need to either
change her default mdw file to the correct one or build a shortcut for her
that specifies the correct mdw file as an argument. The latter is the
preferred method. That way the user is not bothered with logging in except
when they use your secured file.
Chances are one or more of the following is incorrect in your security
setup.
The default user "Admin" still has some permissions to the db (should have
none).
The default group "Users" still has some permissions to the db (should have
none).
The default user "Admin" is still listed as the owner of the db (should not
be).
