I would find it hard to believe that this question is "off on a tangent" for
this listserv.  I suspect that FAR more than a few of us have been grappling
with how we could set up and maintain user-level security in a shared area
on a campus network for our MS Access databases.  PLEASE share what you
learn with the list.   At least I feel that way.  Thank you for sharing your
question!!   I was SO glad to see it!

         ***                          *******                       ***

"A man should hear a little music, read a little poetry, and see a fine
picture every day of his life, in order that worldly cares many not
obliterate the sense of the beautiful which God has implanted in the
human soul."  -- Johann Wolfgang von Goethe
------------------------------------------------------------------
Michelle Sitko
Coordinator of Collection Management Services/Serials
Learning Resources Center
Marywood University
2300 Adams Avenue
Scranton, PA  18509-1598
Voice: (570) 340-6034
Fax: (570) 961-4769
Email: sitko@ac.marywood.edu
URL: http://www.marywood.edu

-----Original Message-----
From: SERIALST: Serials in Libraries Discussion Forum
[mailto:SERIALST@LIST.UVM.EDU]On Behalf Of Diane Neumeister
Sent: Thursday, February 03, 2000 10:30 PM
To: SERIALST@LIST.UVM.EDU
Subject: Need help setting up user-level security for an Access 97
database

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