Email list hosting service & mailing list manager


Need help setting up user-level security for an Access 97 database Diane Neumeister 04 Feb 2000 03:30 UTC

Since this is kind of off on a tangent for this listserv, PLEASE REPLY TO
ME DIRECTLY AT: dneumeis@loras.edu.

I know some of you use MS Access for various serials functions and I
really need help!  I've got a serials database that I had protected with a
database-level security password because only a few people needed access
to it and we all needed access to everything.  Now, I need to make the
database accessible to the entire staff (by putting it in a shared area in
the campus network), but at several different access levels (some read
only, some full rights, some in between).  In short, I need to set up
user-level security.

Can anyone suggest a good instruction/reference book for MS Access 97 that
CLEARLY explains how to set up & maintain user-level security for a
database?  Or would somebody who's knows how to do this be willing to
share their instructions with me?

Please don't suggest using the online help.  Usually online help works,
but my SysAdmin and I tried that and we finally gave up in frustration.
This is too complex an issue: there are so many help topics to navigate
through that it was like trying to find our way through a maze: A refers
you to B. After a couple of steps, B refers you to C. Another step or two
and C refers you to D which refers you back to a later step in B which
then refers you to E and so on.

Any help would be greatly appreciated!

Di

Diane Neumeister
Serials Asst.
Wahlert Memorial Library
Loras College
Dubuque, IA, USA

phone: 319-588-4969
fax: 319-588-7292
e-mail: dneumeis@loras.edu