Errata

Print Print Icon

Submit your own errata for this product.


The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question



Version Location Description Submitted By Corrected
Printed Page xv
The second-to-last paragraph did read

"Most of it applies qually well..."

Now reads:

"Most of it applies equally well..."

 Anonymous  Mar 2001
Printed Page xx
The link to the book's web site in the 2nd paragraph did read


http://www.oreilly.com/catalog/accessdata

Now reads:

http://www.oreilly.com/catalog/9781565926264/

 Anonymous  Mar 2001
Printed Page xx

The text of the "Request for Comments" section has been updated. It now reads:

Request for Comments

Please address comments and questions concerning this book to the
publisher:

O'Reilly & Associates, Inc.
101 Morris Street
Sebastopol, CA 95472
(800) 998-9938 (in the United States or Canada)
(707) 829-0515 (international/local)
(707) 829-0104 (fax)

There is a web page for this book, which lists errata, examples, and
any additional information. You can access this page at:

http://www.oreilly.com/catalog/9781565926264/

To comment or ask technical questions about this book, send email to:

bookquestions@oreilly.com

For more information about books, conferences, software, Resource
Centers, and the O'Reilly Network, see the O'Reilly web site at:

http://www.oreilly.com

 Anonymous  Mar 2001
Printed Page 23

The first line after "Implementing the Relationships in a Relational Database" did read:

"Now let us now discuss..."

Now reads:

"Now let us discuss..."

 Anonymous  Mar 2001
Printed Page 25
In the paragraph before Figure 3-2, The 2 in the sentence beginning

"Suppose also that {A2}..." was changed to a subscript.

 Anonymous  May 2001
Printed Page 27
In Figure 3-3 the right-hand box used to be labeled

"Books"

It now reads:

"Authors"

 Anonymous  Oct 1999
Printed Page 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"

Anonymous  Feb 2000
Printed Page 76

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

Anonymous  Feb 2000
Printed Page 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"

 Anonymous  Feb 2000
Printed Page 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.

 Anonymous  Feb 2000
Printed Page 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).

 Anonymous  Feb 2000
Printed Page 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."

 Anonymous  Feb 2000
Printed Page 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)"

 Anonymous  Feb 2000
Printed Page 126

In Figure 7-2, "Internal IASM" now reads "Internal ISAM".

 Anonymous  May 2001
Printed Page 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)"

 Anonymous  Feb 2000
Printed Page 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)

 Anonymous  Feb 2000
Printed Page 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.

Anonymous  Feb 2000
Printed Page 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".

 Anonymous  Feb 2000
Printed Page 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

 Anonymous  Feb 2000
Printed Page 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.

 Anonymous  Feb 2000
Printed Page 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.

 Anonymous  Feb 2000
Printed Page 203
The first line of first code listing did read


"For ObjectVar ..."

It now reads:

"For Each ObjectVar ..."

 Anonymous  Feb 2000
Printed Page 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.

 Anonymous  Feb 2000
Printed Page 368
The 6th line of the 2nd full paragraph did read:

"...refers to the the MDB..."

Now reads:

"...refers to the MDB..."

 Anonymous  Mar 2001
Printed Page 385
The URL in the first bullet did read

ftp://ftp.oreilly.com/published/oreilly/windows/access.design/
example.zip

Now reads:

ftp://ftp.oreilly.com/published/oreilly/windows/access.design2/
example.zip

 Anonymous  Mar 2001
Printed Page 385
The second bullet did read

/published/oreilly/windows/access.design

Now reads:

/published/oreilly/windows/access.design2

 Anonymous  Mar 2001
Printed Page 385

The name (and content) of the examples file has been changed. The URL in the first bullet now reads "ftp://ftp.ora.com/published/oreilly/windows/
access.design2/CodeAccess2.zip."

 Anonymous  May 2001
Printed Page 385
The second sentence in the second bulleted item on the page now reads

"You can use an ftp client such as WS_FTP32 to ftp..."

 Anonymous  May 2001