Got new pc and lpermissions

[denise]

We have user level security set up on an access database. 2 users got new
pc's and now are not prompted for a user/password and can't use it like they
could before. I didn't set the security up, but need to help them. I also
have had trouble understanding/setting up user level security. What do we
need to do on their new pc's to get these users to work. Thanks very much for
any ideas.

 

[Joan Wild]

We have user level security set up on an access database. 2 users got new
pc's and now are not prompted for a user/password and can't use it like
they
could before. I didn't set the security up, but need to help them. I also
have had trouble understanding/setting up user level security. What do we
need to do on their new pc's to get these users to work. Thanks very much
for
any ideas.

It's likely that the workgroup file (mdw extension) is on the server.

You'd need to give them a desktop shortcut. In the target put
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"

 

[denise]

Would the msaccess.exe be the one on the pc or the server? The .mdb and
secure.mdw would be on the server.

 

[SteveTyco]

It does not matter... Where ever access resides.

Would the msaccess.exe be the one on the pc or the server? The .mdb and
secure.mdw would be on the server.

 

[Joan Wild]

Would the msaccess.exe be the one on the pc or the server? The .mdb and
secure.mdw would be on the server.

On the PC. Also you can use UNC pathnames for the mdb/mdw on the server and
not rely on drives being mapped correctly.

\\server\share\... rather than P:\....

 

[denise]

Thanks a lot, I got it to work using your first suggestion.