Errata

1 error in downloaded examples.
In LIBRARY_FLAT data the author of Jayne Eyre has been changed from Austen to Bronte
but the AuID is 1 for both.

5th line should read
PubID TEXT(10), CONSTRAINT Test FOREIGN KEY (PubID) REFERENCES

and not

PubID TEXT(10) CONSTRAINT Test FOREIGN KEY (PubID) REFERENCES

there is a missing comma which
will cause an sql error.

I can't tell if the sentence "As you can see, the Single-
and Multi-Column Constraint clauses..." matches the last two lines
of the ALTER TABLE syntax just above.

Please consider rewriting the sentence to make it clearer.
Also consider rewriting the syntax (why does "Multi-ColumnConstraint"
only go with "ADD CONSTRAINT" and "MultiColumnIndexName" only go
with "DROP CONSTRAINT"?).

MS' help file is not very clearly written either.

1st line of this code should read

SELECT DISTINCTROW PUBLISHERS.PubID, PUBLISHERS.PubName

instead of

SELECT DISTINCTROW PubID, PubName

otherwise, you will receive an error
stating correctly that PubID may refer
to a column in more than one table in
the FROM statement.

The figure on p. 208 uses light gray for objects and dark gray for
collections; the figure on p. 210 uses dark gray for objects and
light gray for collections. I suggest using a consistent set of
shades in both figures.

Also an "Objects"/"Collections" legend, as in the figure on p. 210,
might be nice.

The example code doesn't run, giving a run-time error. More particularly it gives a
run-time error '13': Type mismatch. This error occurs at the line "For Each prp In
db.TableDefs!BOOKS.Properties" (the quotes are shown here to distinguish the line of
code and are not entered into the module).

The full code I entered is:

Sub exaProperties()

Dim db As Database
Dim prp As Property
Set db = CurrentDb

For Each prp In db.TableDefs!BOOKS.Properties
Debug.Print prp.Name
Next prp

End Sub

This applies to Access '97 (don't know about 2000).

There's a detail about user-defined properties that the example code
won't reveal. I haven't found it in the Access help file either.
You can't add a user-defined property to a field unless the field
has been appended to its table and the table has been appended to
its database. I haven't checked if a similar restriction applies to
the other types of objects that can have user-defined properties.

The strSQL= line is missing closing quotes at the end of the line

To get the result as Table 19-16, a LEFT OUTER JOIN is supposed to be used in the
where clause of the outer SELECT statement.

If the table ComposersOutput does not exist when this program is run, the following
error occurs:
Run-time error '3078'
The Microsoft Jet database engine cannot find the input table or query
'ComposersOutput'. Make sure it exists and that its name is spelled correctly.

Additionally, deleting the column 'Weight' and running this code results in the
following error:
Run-time error '3265':
Item not found in this collection.

Since this code is supposed to dynamically add columns to the table 'ComposersOutput'
it is reasonable to assume that the code should be able to handle one or both of
these conditions.