HomeServicesTechnologyClientsCompanyContact Us

The MS Access Datastore Application

The MS Access data store application design uses a single Back-End MS Access data store connected that is connected to a Windows application Client... typically written in Java or VB or one of the Dot Net languages (C #, Visual Basic .Net).
Using MS Access exclusively as a Data Store is generally useful for "occasionally connected" applications that need to be deployed to a disconnected computer like a laptop or notebook PC for reference information (primarily "read" more than "write"), or data collection that is synchronized periodically to update and share data.
MS Access Datastore Application Scorecard
Number of End Users 1 Desktop only
Application Performance Good Poor application design will impede performance
Application Reliability Good Poor application design will crash the application/corrupt the datastore
Data Integrity Good Limited means to insure data accuracy
Application Security Poor Data wide open to the LAN
Maintenance Burden High Manual only; requires End User to maintain
The MS Access Data Store method can be used to house data on a network file share, however the Data Store approach forces MS Access to handle multi-user data concurrency issues, which are always best handled by a database server.
Limitations to the MS Data Store Application approach generally include data integrity and security issues inherent with all MS Access file-based solutions. As a desktop product, this model does not lend itself to centralized maintenance; MS Access Repair and Compact must be run by the end user. In the end, this design is as costly to develop and deploy as a full Client-Server application, but lacks the full Client-Server benefits of centralized Security, better performance, and ease of maintenance.