User profiles/passwords on a network server

[Kimberly]

I have set up an access program (tools, security) with
several groups and for many different users with different
passwords. The database is on a server which all of the
staff computers will be mapped to to utilize the program.
I set up the groups and passwords however, I don't know
how to activate the program to ask the users for their
user/password information. I have the access bible and on
pg 46 it states the options for starting access but I
don't know where you enter the specified data. I opened
the MSACCESS command line from the properties-but I am
still not clear which page and entry to enter the
information. I also unsuccessfully tried the one-step
security wizard. I am obviously a novice. Please help!

 

[Sal Rosario]

Once you setup groups and users into a workgroup security file (by default
called system.mdw). You need to join each user to that one file. If you are
using Access XP, you can click on Tools...Security...Workgroup
Administrator. Click on the Browse button and find the .MDW file that you
want to join the user to. In a multi-user environment like yours, you would
place that .MDW file on a shared network drive.

If you are using older versions of Access, you can do a Search for the file
WRKGADM.EXE. This will give you the workgroup administrator functionality.

Sal
www.cedrostec.com

Sal
www.cedrostec.com

 

[Simon Guertin]

You could also just specify in the shortcutt needed to
lanch the app, which security file to use.
So you don't have to go and switch the workgroup file on
every computer. After that the user will be prompted for a
user name and password if you don't specify the /user
option in the shortcut