[OpenAFS] MS Access and OpenAFS

[Gabe Castillo]

Has anyone used an MS Access database from within OpenAFS? Does it work 
with multiple users? I'd heard some talk about AFS not supporting 
byte-range locking, and wasn't sure how MS Access fit into this.

Thanks,
 Gabe
___
OpenAFS-info mailing list
OpenAFS-info@openafs.org
https://lists.openafs.org/mailman/listinfo/openafs-info

Re: [OpenAFS] MS Access and OpenAFS

[Jeffrey Altman]

Gabe Castillo wrote:

 Has anyone used an MS Access database from within OpenAFS? Does it work
 with multiple users? I'd heard some talk about AFS not supporting
 byte-range locking, and wasn't sure how MS Access fit into this.
 
 Thanks,
  Gabe

You do not want to execute database applications out of AFS.  AFS does
not support byte range locks.  MS Access requires byte range locks to
protect records during modification.

Jeffrey Altman



smime.p7s
Description: S/MIME Cryptographic Signature

RE: [OpenAFS] MS Access and OpenAFS

[ted creedon]

One can reverse engineer the Access database design with Visio Enterprise
and have Visio emit new definitions for any number of real databases.

AFS is a good place to archive .mdb files.

Being a university, one should investigate SQL server for multiuser
applications. Its Data Transformation Services work quite well. Of course
then you have that to backup.

tedc

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Federico Balbi
Sent: Wednesday, April 20, 2005 2:54 PM
To: Gabe Castillo
Cc: openafs-info@openafs.org
Subject: Re: [OpenAFS] MS Access and OpenAFS

I do not think AFS would be good with concurrent users. AFS is good to share
many small files with low concurrency access. If you have bunch of MDB and
low probability to have 2 users or more using it concurrently then it would
be fine.





Federico Balbi
Division of Computer Science
University of Texas at San Antonio
6900 N. Loop 1604 West
San Antonio, TX 78249-0667

[EMAIL PROTECTED]
http://www.cs.utsa.edu/~fbalbi

On Wed, 20 Apr 2005, Gabe Castillo wrote:

 Has anyone used an MS Access database from within OpenAFS? Does it 
 work with multiple users? I'd heard some talk about AFS not supporting 
 byte-range locking, and wasn't sure how MS Access fit into this.

 Thanks,
   Gabe
 ___
 OpenAFS-info mailing list
 OpenAFS-info@openafs.org
 https://lists.openafs.org/mailman/listinfo/openafs-info


___
OpenAFS-info mailing list
OpenAFS-info@openafs.org
https://lists.openafs.org/mailman/listinfo/openafs-info

___
OpenAFS-info mailing list
OpenAFS-info@openafs.org
https://lists.openafs.org/mailman/listinfo/openafs-info