Access.2007.VBA.Bibl..

TABLE 5.1

New Attributes of the Field2 Object

Attribute Type Name Notes

Property AppendOnly Gets or sets a Boolean value that indicates whether the specified

field is set to append new values to the existing contents of the field

as they are added (Read/Write).

Property ComplexType Represents a multi-valued field (Read-only).

Property IsComplex Returns a Boolean value that indicates whether the specified field is

a multi-valued data type (Read-only).

Method LoadFromFile Loads the specified file from disk.

Method SaveToFile Saves an attachment to disk.

Recordset2

The Recordset2object represents a recordset based on Access 2007 data. Compared with the

old Recordsetobject, it has only one new property, ParentRecordset, representing the par-

ent Recordset of the specified recordset.

Hidden Objects in the Access 2007 DAO Object Model ..................................

The properties and methods listed in Table 5.2 are hidden in the new Access 2007 DAO object

model. The Container, DBEngine, and Workspace objects are visible; only the listed properties and

methods for these objects are invisible. The Group and User objects and the Groups and Users col-

lections are entirely invisible.

TABLE 5.2

Database Components Hidden in the Microsoft Office 2007

Access Database Engine Object Model

Collection or Object Properties Methods Constants

Container AllPermissions

Inherit

Owner

Permissions

UserName

DBEngine SystemDB

Part II Writing VBA Code to Exchange Data between Office Components