Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Subject: Re: MS Access and file security settings
From: Kevin Stephenson (kevin.stephensonPOBOX.COM)
Date: Thu Jul 27 2000 - 06:01:27 CDT

I hope you don't have the idea that Access can be made secure. If you want
to prevent
data modification by a user/group, then you should make a separate copy of
the mdb file and set it to RO for that group. Then block them completely
from the copy set to RW for the other group. You still need to set the file
to shared mode in either case. You also need to setup a system to update
the RO file from the RW one on a periodic basis.

See http://www.lostpassword.com/access.htm for why Access
username/passwords are useless.

At 01:35 PM 7/26/2000 -0400, you wrote:

>Set the default mode to shared, and set up security by using Username's
>and Passwords.
>Timothy M. Mullen, CIO, MCSE
>Anchor Sign, Inc.
>530.550.1046.truckee, ca
>843.576.9422.charleston, sc
>-----Original Message-----
>From: Ryan Casey [<mailto:rcaseyCRP.ORG>mailto:rcaseyCRP.ORG]
>Sent: Wednesday, July 26, 2000 8:57 AM
>Subject: MS Access and file security settings
>Is it possible to have a MS Access 97 database be read only for some and RW
>for others?
>The problem that I run into is if a user with read only access opens the
>db, a RW user cannot open the db because it is being used. Likewise if a
>RW user opens the database first, a Read only user cannot open it because
>it is in-use. Is there a way around this?