Access Passwords on a networked computer

11 Sep 2007 5:22 PM

cwjf

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.

--
Kaye

11 Sep 2007 6:39 PM

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).

--
Joan Wild
Microsoft Access MVP

Show quote

"cwjf" <c***@discussions.microsoft.com> wrote in message news:FAABB947-3169-437A-A06B-5FE646D1AEF5@microsoft.com...
> 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.
> --
> Kaye