F. Scott Barker’s Microsoft Access 2002 Power Programming

Chapter 3. Making Access Project and Data Technologies Choices

IN THIS CHAPTER

• Using Microsoft Database Versus Access Database Project 72

• Using DAO Versus ADO Versus XML 75

Before Access 2000, when you created an application, you had to plan whether you wanted to use a Jet (the database engine Access uses natively) or a client/server back end. Depending on the type of back end chosen, you would use various methods to create the application. Although this is still the case, you now have more choices to make when starting on a project. Now, in addition to the back-end choice, you must decide what type of database container to use: the traditional MDB or ADP.

The other choice to make is the method of accessing the data while working in VBA: DAO (Data ...