Errata

Access 2000 Developer's Handbook
Volume II, Enterprise Edition

Back to errata

Last updated 19 November 2001.

Chapter

Page

Where

Replace

With
2 (Added 3/29/2001)

20

Down 1/3 of the page

If IsNull(varFileName) Then

If Len(varFileName & "") = 0 Then
2 (Added 3/29/2001)

Not in book

In basFileOpen, in adhCommonFileOpenSave, modify the error handler:

Select Case Err.Number
  Case cdlCancel
    Err.Raise cdlCancel, , _

     "User cancelled the dialog."
  Case Else
    MsgBox "Error: " & Err.Description & _

     " (" & Err.Number & ")"
End Select

 

Remove the "Case cdlCancel" section:

Select Case Err.Number
  Case Else
    MsgBox "Error: " & Err.Description & _
     " (" & Err.Number & ")"
End Select

 

2 (Added 5/1/2001)

62

Listing 2.11

Replace this:

Set rstPessimistic = New ADODB.Recordset

' Open a keyset recordset with optimistic locking
rstPessimistic.Open "tblCustomer", cnn, adOpenKeyset, _
 adLockPessimistic, adCmdTable
Stop

rstPessimistic.MoveFirst
     rstPessimistic!City = "Chicago"
    ' Record locked at the moment the
    ' update is committed to the database.
rstPessimistic.Update

with this:

Set rstPessimistic = New ADODB.Recordset

' Open a keyset recordset with pessimistic locking
rstPessimistic.Open "tblCustomer", cnn, adOpenKeyset, _
 adLockPessimistic, adCmdTable
Stop

rstPessimistic.MoveFirst
    ' Record locked at the moment the
    ' first field is dirtied.
    rstPessimistic!City = "Chicago"
rstPessimistic.Update

3 (Added 5/4/2000)

114

First full paragraph

When you convert an application from using Jeta data to using ODBC data... When you convert an application from using Jet data to using ODBC data...

3 (Added 5/4/2000)

149

Paragraph beneath Figure 3.8

For example, you could define a trace to include only those statement sent from the application "Microsoft Access".

For example, you could define a trace to include only those statements sent from the application "Microsoft Access".

3 (Added 5/4/2000)

151

Step 5

The ODBC driver creates a stored procedure to retrieve additional all records from the table.

The ODBC driver creates a stored procedure to retrieve additional records from the table.

3 (Added 5/4/2000)

151

Step 8

Jet calls this stored procedure twice values to place on the form.

Jet calls this stored procedure twice to place values on the form.

4 (Added 5/5/2000)

156

2nd sentence under "SQL Server Versions" head

...right from with the Access 2000 user interface...

...right from within the Access 2000 user interface...

8 (Added 9/9/2001)
 396 First paragraph, last line ...permissions in ADXO using methods... ...permissions in ADOX using methods...
10 (Added 9/28/2000)

589

Sidebar, "Binding Hyperlinks to Hyperlink Fields"

=document.all("MDSODSC").hyperlinkpart

 =document.all.msodsc.hyperlinkpart

16 (added 10/20/2000)

961

Code sample under "Tips and Workarounds"

$(AppPath)\Customers.mdb
/runtime/wrkgrp$(AppPath)\Corporate.mdw

$(AppPath)\Customers.mdb 
/runtime/wrkgrp $(AppPath)\Corporate.mdw 
(add a space between wrkgrp and the name of the workgroup file)

Back to errata