Alison Balter's Mastering Access 2002 Enterprise Development

Building the Middle-Tier Component

To move an application to the n-tier model, you must remove all data access code from the user interface and place it in a DLL. Here are the steps involved:

1.	Launch Visual Basic.
2.	Indicate that you want to create an ActiveX DLL (see Figure 14.2) and click Open. The Visual Basic environment appears as in Figure 14.3. Figure 14.2. Launch Visual Basic and create an ActiveX DLL project. Figure 14.3. The Visual Basic environment after creating an ActiveX DLL project. [View full size image]
3.	Return to the Access ...