Access Database Design & Programming, Second Edition
by Steven Roman


This page contains changes made in the 2/00 reprint.


Here's a key to the markup:

        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification



{71} At the bottom of the page, the phrase at the end of the code
listing did read:

        "Ck=D1"

It now reads: 

        "Ck=Dk" 


{76} Entry in row 4, column 6 of the last table did read "h"; it 
now reads "j". 


{98} The code listing in the middle of the page did read:

		"TOP number [PERCENT]

	or:
        
		TOP percent [PERCENT]"

It now reads:

		"TOP number
	or:
        
		TOP percent PERCENT"


<101> The first three tables on this page have been identified as
"Temp1," "Temp2," and "Temp3," respectively, because they are referred 
to as such in the code directly below them.


(102) In the second table, the entry in row 2 to has been changed to "a2" 
and the entry in row 3 has been changed to "a3" (in other words, the 
numbers are nolonger subscripts).


{111} In the last line before the "The SELECT... INTO Statement,"
the line did read:

	"Text values must be enclosed in double quotation marks ("")."

It now reads:

	"Text values must be enclosed in quotation marks."


{122} The last code listing did read:

	' Get current database
	Set dbs = CurrentDb()

	' Write SQL statement
	strSelect = "Select * FROM Books WHERE Price=10"
	Chapter 7, Database System Architecture
	' Open recordset using SQL statement
	Set rsCheap = dbs,OpenRecordset(strSelect)

It now reads:

	' Get current database
	Set dbs = CurrentDb()

	' Write SQL statement
	strSelect = "Select * FROM Books WHERE Price=10"

	' Open recordset using SQL statement
	Set rsCheap = dbs,OpenRecordset(strSelect)"


{163} Under the "Arrays" heading, the second set of code did read:

	"Names(1), Names(2),..., Names(10)"

It now reads:

	"MyFields(1),MyFields(2),...,MyFields(10)"


{177} The first code listing under the "Named Arguments" heading did read:

	Set rs = CurrentDb.OpenRecordset("Names", dbOpenForwardOnly)

The word "Names" has been changed to "Objects". It now reads:

	Set rs - CurrentDb.OpenRecordset("Objects", dbOpenForwardOnly)


{184} In Figure 12-1, the command buttons were labeled "OK" and "Cancel".
They are now labeled "Yes" and "No" as specified in the text. 


{187} In the first section, there are three occurrences of the word "Instr". 
In each case, the "s" has been changed to uppercase, and now reads: "InStr".


{191} In the first code listing, the second to last line of code did read:

        s = IIF(IsNull(rs!LastName)), "", rs!LastName)

It now reads:    
        
        s = rs!LastName


{198} In the first listing of code, the second to last line of code that reads:

        rs.Close

has been removed, and the space between the last two lines has been closed up.


{202} The last line of the first paragraph, which read:

	"We also should not rely on the value of the loop counter outside of 
	the For loop, since, once the loop is finished, its value is undefined."

has been deleted.


{203} The first line of first code listing did read:
        
        "For ObjectVar ..."

It now reads:

       "For Each ObjectVar ..."


{216} In the right column of the table,
 
        "or dbs" has been removed from row 3
        "or rst" has been removed from row 14
        "or wrk" has been removed from the last row.