User Groups & passwords

[oliver_penney]

aaaaagh



i have a db on a shared drive, and i set up usergroups, members and passwords, and it asks me my username when i log in

but if i go to a different machine on the network, it stops asking for a username



any clues?

ol

 

[mdmilner]

I can't remember the name of the file exactly, but when setting up security, access sets up a workgroup file that stores information. I *believe* the extension on the file is *.mdw and it should be located in the root directory for the Access.EXE executable.

SYSTEM.MDW

Mike

 

[oliver_penney]

ah

found that thanx

now what? do i need to put that on the shared drive?

regards

ol

 

[mdmilner]

Don't use these alot myself, but, I believe it can be setup two ways.
Each machine can have a unique system.mdw file and each access database can have a unique system.mdw file that controls all access by all users connecting to it.

I don't have a chance today to test it, but I think the answer is yes: move it to the share drive.

Mike