Errata

Access Database Design and Programming

Errata for Access Database Design and Programming

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 "Date 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 Note Update

Version Location Description Submitted By Date submitted Date 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 01, 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 01, 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 01, 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 01, 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 01, 2001
Printed
Page 27
In Figure 3-3 the right-hand box used to be labeled

"Books"

It now reads:

"Authors"

 Anonymous    Oct 01, 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 01, 2000
Printed
Page 76

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

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

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

 Anonymous    May 01, 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 01, 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 01, 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 01, 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 01, 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 01, 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 01, 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 01, 2000
Printed
Page 203
The first line of first code listing did read


"For ObjectVar ..."

It now reads:

"For Each ObjectVar ..."

 Anonymous    Feb 01, 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 01, 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 01, 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 01, 2001
Printed
Page 385
The second bullet did read

/published/oreilly/windows/access.design

Now reads:

/published/oreilly/windows/access.design2

 Anonymous    Mar 01, 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 01, 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 01, 2001