[OpenAFS] MS Access databases on AFS

[Jeffrey Altman]

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig986FC2B1DF5A0A0796426301
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On 9/22/2010 9:50 AM, Richard Heggs wrote:
> Hi Dirk,
>=20
> Yes, I agree with everything you say.  As I said in my first post, I am=

> working on a replacement) with PostgreSQL at the back and a web
> frontend). That is some months away to completion, though, and they nee=
d
> a temporary solution *now*.
>=20
> I was horrified when I learned that they were keeping critical data in =
a
> MS Access database.  And even more horrified when I learned that it was=

> backed up "whenever someone remembers"!
>=20
> Richard

MS Access will request byte range locks on the db-file.  Those will be
converted to full file locks in AFS by the cache manager.  You won't be
able to share the database in AFS.  However, since AFS locks are
advisory there is nothing to prevent someone with authorization and
malicious intent to delete the file or write over it.   That is of
course true with any file in AFS.

Jeffrey Altman


--------------enig986FC2B1DF5A0A0796426301
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)

iQEcBAEBAgAGBQJMmjVnAAoJENxm1CNJffh4ri4IAKTSxttnua0cV+z5WrpvFy2Z
vw2eJhK6zso4BbfrE7pbwe63mVWCBMOrHHn3IH23KbdHMIzoalaoBoTBqj+oy4hh
xETzMtY0uOnt0z4YNrvoDU+vXRhJ3sdUUjOAngeoQzJ1zt7dTQZEyzm9Z/0dwO75
8wE86P8no3CGUH97i+XBlrOB2/nS1md1Dl9iF/kD6BKZW9TwrbPYTneKjlhkMnmG
puk/X2XvOWs1XUC6i06VrRBmKHghaj3m1d8Byk6YdU9+86T+RQK55VpUs4KGb8T2
S1Ks7DwGOOfYvPzY6s4sROxN3RMT+Dox/jg7k6rMxXnpeM3+fkmNshsEfaDWRtk=
=+qSa
-----END PGP SIGNATURE-----

--------------enig986FC2B1DF5A0A0796426301--