OSEC

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: Russel Morrison (morrisonOPTUSHOME.COM.AU)
Date: Thu Jul 27 2000 - 16:06:31 CDT

A better method is to split the database and use two different intefaces to
connect to the data. One can be set to only read nad the other to read and
write by using the properties of the forms used. Ensure that you create a
mde file for added security
----- Original Message -----
From: Kevin Stephenson <kevin.stephensonPOBOX.COM>
To: <FOCUS-MSSECURITYFOCUS.COM>
Sent: Thursday, July 27, 2000 9:01 PM
Subject: Re: MS Access and file security settings

> 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
> >530.550.1467.fax
> >843.576.9422.charleston, sc
> >tmullenanchorsign.com
> ><http://www.anchorsign.com/>http://www.anchorsign.com/
> >
> >-----Original Message-----
> >From: Ryan Casey [<mailto:rcaseyCRP.ORG>mailto:rcaseyCRP.ORG]
> >Sent: Wednesday, July 26, 2000 8:57 AM
> >To: FOCUS-MSSECURITYFOCUS.COM
> >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?
> >
> >Thanks!
>