• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Building N-Tier Applications > Access and a Logical Three-Tier Mode...

Access and a Logical Three-Tier Model

Sometimes you might suspect that you will need to move to a true three-tier model in the future, but you are not ready to do so yet. Other times, you might want to take advantage of Access's rapid application development environment to perfect your three-tier architecture. In either case, you can build a model that is logically three-tier, while retaining all of the application components within Microsoft Access. The process involves moving all data access logic into class modules and ensuring that the application forms contain no data access logic. The sections that follow illustrate this process.

Populating the Form with Data

The example shown in this chapter is the same example shown in Chapter 13. Figure 14.1 shows the data entry form. The difference with the example shown in this chapter is that the data access code is no longer located in the Access user interface. Instead, I have moved it to a class module within the Access database.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint