Access 2007 Programming by Example with VBA, XML, and ASP

Chapter 10Data Access Technologies in Microsoft Access

Microsoft Access has been effectively used by people all over the world for organizing and accessing data. While each new software release brought numerous changes in the design of the user interface and offered simpler ways of performing common database tasks, database access has evolved at a little slower pace.

This chapter begins with the introduction of the old (Jet) and the new (ACE) database engines and proceeds to an overview of Access versions and file formats supported by Microsoft Office Access 2007. This is followed by a review of data access methods that programmers and database developers can use to read, write, and manipulate data in Access databases (in MDB and the new ACCDB ...