Access Database Design and Programming
by Steven Roman


Here are the changes that were made in the 3/99 reprint:


{48} Changed the display from

	{ISBN, PubPhone} and {PubPhone, PubName}
to

	{ISBN, PageCount} and {PageCount, Price}


{101} Changed the sentence after Table 6-7 from

	"This is, in fact, the semi-join"
to

	"This is, in fact, a projection of the semi-join"


{122} Example 7-1, removed the line: dbLibrary.Name = "LIBRARY"


{123} Changed the line

	Set dbLibrary = ws.OpenDatabase("d:\dao\library.mdb")
to

	Set dbLibrary = DBEngine.OpenDatabase("d:\dao\library.mdb")


{157} Changed the line

	"of the previous example, we could have written"
to

	"we can write"


{193} Changed the line

	strSQL = "UPDATE BOOKS SET Price = Price*1.1 WHERE Price > 20"

to

	strSQL = "UPDATE BOOKS SET Price = Price*1.1"


{193} Changed the line

	If qdf.RecordsAffected > 15 Then

to

	If qdf.RecordsAffected <= 15 Then


{202} Replaced the line

	Msgbox rsTable!Title

with the two lines

	If Left$(tsTable!Title,2) = "On" then
	Msgbox rsTable!Title


{232} In Table B-4:

	1. Changed the last cell in the last row to "red oak"
	2. Added another row with first cell "Fred's Woods" and second cell
			   "poplar."
	3. Added another row with first cell "Fred's Woods" and second cell
			   "mahogany."


(231) Replaced double arrow symbol with a large X, as on page 62 under the
	       definition of cartesian product.


(237) In paragraph numbered 4, in the second to last line, changed "right" to
         "left."


(238)  In the table at bottom: changed Meville to Melville.


<245> Two headings were added at the beginning of the index: "Symbols," and
           "Numbers."


<246> In column 1, line 13:

	"for specific objects, ??-229, 210-??"

was changed to:

	 "for specific objects, 210-229"