Access.2007.VBA.Bibl..

FIGURE 5.2

The default Access 2007 DAO reference in a new Access 2007 database.

Working with Older Format Databases in Access 2007 ......................................................

Even if you are currently using Access 2007, you may still be working with Access 2002/2003 for-

mat databases (or even Access 2000 format databases) for a while. Access 2007 supports working

with these older database formats in read/write mode, and you may need to do this — for example,

if you are working on a database for a client running an older version of Office. So long as you

don’t need to use any of the new features introduced in Access 2007 (such as multi-valued lookup

fields, or rich text in Memo fields and attachments), you can continue to work with databases in

2000 or 2002/2003 format in Access 2007 without converting them to the new database format.

Disambiguating References to Object Model Components ........................................

When DAO was the only object model you could use to work with Access data, when you declared

DAO objects there was no need to indicate which object model your objects belonged to — you

could just declare a recordset variable as Recordset, or a field variable as Field (as in the following

declarations), and your code would work fine:

Dim rst as Recordset

Dim fld as Field

But since the introduction of the ADO object model, you may run into problems with such decla-

rations, because certain object names are used in both of these object models. This is true of the

Working with Access Data 5