Microsoft® Office Access™ 2007 Inside Out

Errata for Microsoft® Office Access™ 2007 Inside Out

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
Other Digital Version

The welcome tab link to search the eBook is broken The link to search the eBook on the Welcome tab of the CD interface is broken. To search the eBook, open it and search using the viewing software.

Microsoft Press  May 06, 2010 

**NOTE** If for any reason you are unable to install the practice files from the CD, the files can also be downloaded from the web at

Microsoft Press  Nov 11, 2005 
Page *

**NOTE** Pages 1445 and above (chapters 26-29) can be found on this book's CD. These pages represent bonus content not found in the printed book. If you own an ebook version of this title, the bonus chapters can be found here:

Microsoft Press  May 14, 2011 
Page 143
2nd paragraph 3rd line

On page 143, the book suggest opening a template online. "Click the Business category under Template Categories to see the list of business template options, as shown in Figure 4-2." Figure 4-2, in my book, shows 11 different templates, while the same business categories referred to on my version of Access shows 20 different templates and DOES NOT SHOW THE CONTACTS TEMPLATE REFERRED TO IN THE NEXT PARAGRAPH.

Note from the Author or Editor:
At time of release, the Business category did show a Contacts sample database. When you click Business today (and are connected online), you won't see Contacts, but you will see Contact Management, which is essentially the same database. A small change in the text to tell the user to look for the Contacts Management sample would resolve this tiny problem.

Anonymous  Nov 27, 2010  Aug 31, 2012
Page 382

I think you have to correct the following sentence p.382 " If you try .....that prevents you from setting a DailyRate value that when multiplied by 7 is more than the WeeklyRate" by " If you try .....that prevents you from setting a DailyRate value that when multiplied by 7 is less than the WeeklyRate "

Anonymous  Mar 05, 2010  Aug 31, 2012
Page 518

Database "contacts.accdb" contains an incorrect reference to msadox.dll On page 518, a NOTE needs to be added before the 2nd paragraph under the "A Tour of Forms" heading. The NOTE should read: "NOTE: After opening the "contacts.accdb" file you may encounter an error which states that the database has a missing or broken reference to the file "msadox.dll". The reference to "msadox.dll" is incorrect in the contacts.accdb sample database, this error may affect form functions. Please use the following instructions to fix the problem: 1) Start Access 2007 and open the database "contacts.accdb". 2) You will receive an error stating that the file "msadox.dll" is missing and it may be needed for the database to function correctly. Click "OK" until the error message stops appearing and you're at the main screen in Access which displays the contents of the database on the left hand side. 3) At the top of the screen click on the "Database Tools" tab. 4) At the far left of the menu that appears click on "Visual Basic". The Microsoft Visual Basic – Contacts window appears. 5) On the menu bar click on the "Tools" menu then click on "References". The References – Contacts window will appear. 6) Under "Available References:" there are a list of references that are needed for the database. You will notice that one of the references reads "MISSING - Microsoft ADO Ext. 6.0 for DLL and Security". Clear the checkbox to the left of this reference. 7) Scroll down the list of Available References until you find the "Microsoft ADO Ext. 2.8 for DDL and Security" reference. 8) Click the checkbox next to the "Microsoft ADO Ext. 2.8 for DDL and Security" reference. Please note, if you do not have this reference listed you may need to install "Microsoft Data Access Components (MDAC) 2.8" which can be found here.9) On the References – Contacts window click on "OK". 10) On the Microsoft Visual Basic – Contacts window click on "File" then click on "Save Contacts". Then click on "File" then "Close and Return to Microsoft Office Access" 11) You should now be able to use the contacts.accdb database without issue. If any other error appears after this just click on "OK" as they should not affect the use of the database." Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections.

Microsoft Press  Jul 13, 2010