Microsoft KB Archive/937631

= Microsoft Office Access 2007 Inside Out comments and corrections =

Article ID: 937631

Article Last Modified on 6/13/2007

-

APPLIES TO


 * Microsoft Office Access 2007 Inside Out, ISBN 0-7356-2325-2

-



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book Microsoft Office Access 2007 Inside Out, 0-7356-2325-2.

The following topics are covered:


 * CD-ROM: The welcome tab link to search the eBook is broken
 * Page 518: Database &quot;contacts.accdb&quot; contains an incorrect reference to msadox.dll



CD-ROM: 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.

Page 518: Database &quot;contacts.accdb&quot; contains an incorrect reference to msadox.dll
On page 518, a NOTE needs to be added before the 2nd paragraph under the &quot;A Tour of Forms&quot; heading. The NOTE should read:

&quot;NOTE: After opening the &quot;contacts.accdb&quot; file you may encounter an error which states that the database has a missing or broken reference to the file &quot;msadox.dll&quot;. The reference to &quot;msadox.dll&quot; 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 &quot;contacts.accdb&quot;.

2) You will receive an error stating that the file &quot;msadox.dll&quot; is missing and it may be needed for the database to function correctly. Click &quot;OK&quot; 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 &quot;Database Tools&quot; tab.

4) At the far left of the menu that appears click on &quot;Visual Basic&quot;. The Microsoft Visual Basic – Contacts window appears.

5) On the menu bar click on the &quot;Tools&quot; menu then click on &quot;References&quot;. The References – Contacts window will appear.

6) Under &quot;Available References:&quot; there are a list of references that are needed for the database. You will notice that one of the references reads &quot;MISSING - Microsoft ADO Ext. 6.0 for DLL and Security&quot;. Clear the checkbox to the left of this reference.

7) Scroll down the list of Available References until you find the &quot;Microsoft ADO Ext. 2.8 for DDL and Security&quot; reference.

8) Click the checkbox next to the &quot;Microsoft ADO Ext. 2.8 for DDL and Security&quot; reference. Please note, if you do not have this reference listed you may need to install &quot;Microsoft Data Access Components (MDAC) 2.8&quot; which can be found here.

9) On the References – Contacts window click on &quot;OK&quot;.

10) On the Microsoft Visual Basic – Contacts window click on &quot;File&quot; then click on &quot;Save Contacts&quot;. Then click on &quot;File&quot; then &quot;Close and Return to Microsoft Office Access&quot;

11) You should now be able to use the contacts.accdb database without issue. If any other error appears after this just click on &quot;OK&quot; as they should not affect the use of the database.&quot;

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.

Additional query words: 0-7356-2325-2 978-0-7356-2325-5

Keywords: KB937631

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.