Using Access as a Front End
If you're planning to use Access as a front end to other databases, you need to consider a few issues. In fact, the whole design methodology of your system will differ depending on whether you plan to store your data in an Access database or on a back-end database server.
In a system in which your data is stored solely in Access tables, the Jet Engine supplies all data-retrieval and management functions and handles security, data validation, and enforcement of referential integrity.
In a system in which Access acts as a front end to client/server data, the server handles the data-management functions. It's responsible for retrieving, protecting, and updating data on the back-end database server. In this scenario, the ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
