Access and a Physical Three-Tier Model

To move an application to an n-tier model, all data access code must be removed from the user interface and placed in the .dll. You must reference the business object from the Access application. If you built your application with a logical three-tier model, your application will require only minor modifications. Otherwise, you must modify the front end to instantiate the business object and execute its methods. As with the logical three-tier model, you must pass necessary information, such as the values of text boxes, to the methods on the back end.

Preparing the Access Database for a Physical Three-Tier Model

You must take two steps to prepare the Access database to utilize the DLL that you built. First, ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.