Email list hosting service & mailing list manager


Re: Need help setting up user-level security for an Access 97 database (3 messages) Birdie MacLennan 04 Feb 2000 23:56 UTC

3 messages, 151 lines:

(1)-------------------------
Date:         Fri, 4 Feb 2000 12:24:37 -0600
From:         Diane Neumeister <DNEUMEIS@LORAS.EDU>
Subject:      Re: Need help setting up user-level security for an Access
              97 database

Since Michelle and I are not the only ones interested in this information
(most of the replies I've received have been requests for information),
I'll be happy to summarize to the list in a week or so.

So far, the main book people are recommending is: Using Access 97 (or
Using Microsoft Access 97) by Que Corp or an earlier or later edition of
the book, depending on what version of MS Access is being used.

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

(2)---------------------------
Date:         Fri, 4 Feb 2000 14:27:26 -0600
From: "       "Kevil, L H." <KevilL@MISSOURI.EDU>
Subject:      Re: Need help setting up user-level security for an Access 97 database

The best book on Access 97 I have seen is:

Roger Jennings, Using Access 97 (Platinum edition). Que, 1997, $65 list,
hardback, with CD. ISBN: 0-789714116

It is at home so I cannot verify that it covers security in detail, but I
would be surprised if it did not. Jennings knows his stuff. Of course now
that I am using Access 2000, I don't use that book any more. Jennings did
write a new Special edition Using Access 2000, which I like a little better
than Cary Prague's Access 2000 Bible. Both authors really know their stuff.

L. Hunter Kevil,
Collection Development Librarian,
176 Ellis Library,
University of Missouri-Columbia,
Columbia, MO 65201
Voice:  573-884-8760
Fax:    573-882-6034
E-mail: KevilL@missouri.edu

(3)--------------------------
Date:         Fri, 4 Feb 2000 12:05:50 -0600
From:         "Buddy Pennington" <buddy.pennington@ROCKHURST.EDU>
Subject:      Re: Need help setting up user-level security for an Access 97 database

I am so glad this is on the list as well.  We are dealing with the same
problem.  We want users to be able to view the records in the database
without a password, but if anyone tried to make changes to it, they would
have to enter a password.  Can this be done, and how?

Buddy Pennington
Acquisitions/Serials Librarian
Rockhurst University Greenlease Library
buddy.pennington@rockhurst.edu
#816-501-4143

-----Original Message-----
From: Michelle Sitko [mailto:sitko@MARYWOOD1.MARYWOOD.EDU]
Sent: Friday, February 04, 2000 12:02 PM
To: SERIALST@LIST.UVM.EDU
Subject: Re: Need help setting up user-level security for an Access 97
database

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