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, ...