Re: Need help setting up user-level security for an Access 97 -- L. Hunter Kevil Stephen D. Clark 07 Feb 2000 14:18 UTC

Overnight I took a look at Roger Jennings' _Using Access 97 (Platinum
edition_). Chapter 25, pp.877-924, "Securing Multiuser Network
Applications," should contain most, if not all, the answers you need.
Subchapter titles include: Maintaining database security, Permissions
for
database objects, and Sharing databases on the network. Jennings also
discusses issues such as splitting the database for security. You can
learn
a lot from this impressive book.

Buddy, you can contact me privately about your problem.

Hunter

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

-----Original Message-----
From: Birdie MacLennan [mailto:bmaclenn@zoo.uvm.edu]
Sent: Friday, February 04, 2000 5:56 PM
Subject: Re: Need help setting up user-level security for an Access 97
database (3 messages)

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
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-----

Sent: Thursday, February 03, 2000 10:30 PM
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