Access Passwords on a networked computer

G

Guest

Using Access 2003: We have two computers networked so that Access will be
available for work from both computers. There are 3 user groups: One 'admin'
requiring a password, one that is 'read only' with no password and one
'updater' group that requires a password to log on. There are only 3 user
accounts other than myself as admin.
Two problems:
1. I am the only one that can sign on to the database on the slave
computer---none of the passwords for the other 3 users will open the db on
the slave. I sign on as Admin with my password.
2. I'm having trouble setting the 3rd user with a password that works
even on the host computer and I think I am setting it the same way I did the
others. The other two users have no problem logging on to the database from
the host computer using the passwords that I set for them. To set her
password I've been going to Tools>Security>User Accounts>Clicking
'New'>assigning a name and password and OK. But then I can't sign in using
that user name and password. Am I doing something wrong?

Concerning the slave---do you have to set the passwords there also. It
seems to me that if the passwords are set on the home computer, then they
should work on the slave?????
Thanks for your help.
 
J

Joan Wild

Ensure users have create/read/write Windows permission on the folder where the mdb/mdw is located.
When creating a user via the menus, you do not assign a password. You assign a PID (that's not a password). A new user's password is initially blank.

Try logging in with a blank password. Then you can go to the Tools, Security, User and Group Accounts, Set password tab and create a password for that user (but only because you are logged in as them).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top