January 17, 2004

Access for BackEnd DBs

A personal preference of mine is not to use Microsoft Access as a backend for a database.

Access has a tendency to behave poorly with many users or hits at the same time. Also alot of people forget to close all sessions to access and leave a .ldb file out there when a copy is made. The .ldb file indicates which records are locked and by whom on a shared database.

Microsoft Access also has size limitations. 1 GB for Access 97, 2 GB for Access 2002 and 2000.

Access Corruption occurs under varying circumstances found here.

Posted by Elyse at January 17, 2004 8:15 AM | TrackBack
Comments
Post a comment









Remember personal info?