MS Access 2007 Inside Out, page 208

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Two issues regarding page 208:

1. When I go to open the Contacts.accdb database from the installed
companion CD I see four Access files for "Contacts." All four do not have
their extentions listed. This makes it diffecult to select the correct one.
So I guess my question is how can I see the file extentions?

2. When I finally opened up the Conrad Systems Contacts I got the following
error message: "Your Microsoft Access 2007 Inside Out - Conrad Systems
Contacts database or project contains a missing or broken reference to the
file 'msadox.dll' version 6.0. To ensure that your database or project works
properly, you must fix this reference." How do I go about fixing this?
 
For future reference Stan, specific questions about the book material should
probably be sent to us directly instead of public newsgroups and online
forums.

Now to your question, here is John's reply to your private e-mail message:
Stanley-

To solve #1, you need to set Windows Explorer to "Show File Extensions for
Known File Types." To do that in WinXP, open Windows Explorer and choose
Folder Options from the Tools menu and then select the View tab. I don't
know the exact steps on a Vista system.

For #2 - that's the first time someone has reported this problem. To fix
it, open the VB Editor and choose References from the Tools menu. Clear the
check box next to the MISSING entry and go search for Microsoft ADODB
library and check that. Access is apparently not updating the reference on
your machine. After fixing the references, choose Compile from the Debug
menu to ensure the project compiles OK.
--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 
Back
Top