Microsoft Access 2000 User Level Security

[pimlotb]

Hi

Im pretty new to Access security and was lloking for some advice. I am
looking to setup user level security on a Access db and am having the
following problem.

When I setup the users and passwords in a standalone environment it
will work fine. However the DB is accessed by the users over a network
share and when they open up the DB they are still prompted to enter
the admin db password and are not prompted to enter a username and
password. I have copied over the system.mda security and associated
files into the same directory as the db on the network share


All the machines are running Windows XP with MS Access 2000.

Would appreciate any advice

 

[Rick Brandt]

Hi

Im pretty new to Access security and was lloking for some advice. I am
looking to setup user level security on a Access db and am having the
following problem.

When I setup the users and passwords in a standalone environment it
will work fine. However the DB is accessed by the users over a network
share and when they open up the DB they are still prompted to enter
the admin db password and are not prompted to enter a username and
password. I have copied over the system.mda security and associated
files into the same directory as the db on the network share


All the machines are running Windows XP with MS Access 2000.

Would appreciate any advice

Sorry, but that makes no sense. When using a workgroup file with a password on
the Admin user you are prompted to login with a user name and password. You
cannot be "prompted to enter the admin db password" you are simply prompted to
enter "SOME" user name and password. If the box is pre-populated with the user
"admin" then just have them change that. The prompt will remember the last user
name entered per-PC, but that doesn't mean that you can't change it.