The Roles Access Plays in the Application Design Model

This section takes a look at the many different roles Access can take in an application design.

The Front End and Back End as Access MDB Files

Earlier in this book, you learned about using Access as both the front end and the back end. The Access database is not acting as a true back end because it is not doing any processing. Figure 3.3 shows the architecture in this scenario. The Access application resides on the workstation. Access uses the Microsoft Jet Engine to communicate with data stored in an Access MDB database file stored on the file server.

Figure 3.3. Access as a front end using an MDB file for data storage.

The Front End as an MDB File Using Links to Communicate to a Back End ...

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.