Errata

Microsoft® Office Access™ 2007 Step by Step

Errata for Microsoft® Office Access™ 2007 Step by Step

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page 70
step 8.

After trying to execute step 8 page 70, the following errors are viewed.

FIRST ERROR POSTED
"Cannot find the specified schema file '06_OrderDetails.xsd'. Remove or update the file reference, and try again to import."

SECOND ERROR POSTED
"The file 'C:\...\OrderDetails.xml' does not exist."

The "Populating" directory consists of the following files after running StartCD.exe from the books CD;

Customers.xlsx
Employees.txt
ImportAccess.accdb
ImportDbase.accdb
ImportExcel.accdb
ImportHTML.accdb
ImportText.accdb
ImportXML.accdb
ImportXML.laccdb
NewCust.html
OrderDetails.xml
OrderDetails.xsd
Orders.xml
Products.accdb
Ship.dbf


I fixed the issue by renaming the "Order*.*" files as depicted in the book (page 69).

INCORRECT CORRECTION
OrderDetails.xml 06_OrderDetails.xml
OrderDetails.xsd 06_OrderDetails.xsd
Orders.xml 06_Orders.xml

 Brian Cassidy  Aug 10, 2010 
Printed, PDF Page 70
Step 8

Confirmed previously logged error. Cannot import OrderDetails.xml as it refers to its schema being in 06_orderdetails.xsd (when opened with IE). Renaming OrderDetails.xsd to 06_OrderDetails.xsd resolves this issue. I did not need to rename the .XML files.

 Norman Aitken  Dec 27, 2010 
Printed Page 70
Item 8.

When I tried to import the OrderDetails.xml file I got an error. The first was "cannot find the specified schema file '06_OrderDetails.xsd' Remove or update the file reference and try again to import" I clicked OK then the next popup was "OrderDetails does not exist".
The files are on my computer where they should be. Also I opened the .xml file and saw the data. Both the .xml and .xsd were in the folder.
Why won't it import the files?

 Tom Force  Jan 31, 2013 
Printed Page 74
step 2

Page 74, Step 2 - Received Error Message "Object or class
does not support the set of events"

I was running Windows 7 and Office 2007 SP3 and no other versions.
Windows and Office fully up to date with patches.


I got an error message on Step 2 "Import from Outlook"
"Object or class does not support the set of events"


After searching for ages, found a fix to correct this error
Ran "Fix it for Me" from following site.
http://support.microsoft.com/kb/2687441

 Anonymous  Sep 26, 2013 
Printed, PDF Page 76
Step 4

Cannot import dBASE file. Access returns "Index not found" error.

 Norman Aitken  Dec 27, 2010 
Printed Page 76
Item 4

Cannot import 09_Ship.dbf. Access returns "Index not found" error. Confirms Norman Aitken's error post from Dec 27, 2010

Ken Creppin  Apr 11, 2012 
Other Digital Version 190
top

The instruction is to create an INPUT MASK, Input Mask, type >L<??????????????????

Lambert, Joan; Lambert, Steve; M. Dow Lambert III (2009-12-07). Microsoft? Office AccessTM 2007 Step by Step (Step By Step (Microsoft)) (p. 191). Microsoft Press. Kindle Edition.

But when tried, the cell shows underlines, starts in the middle of the underlines, and then gives an error message that says the input does is not correct.

 Reginald  Oct 13, 2011 
Printed, PDF Page 257
Step 18.

'Report or Switchboard' for 'Preview/Print Products' should not be 'Open Report'. It probably should be 'Alphabetical List of Products'.

 Norman Aitken  Jan 22, 2011