Access 2010 Inside Out Contacts DB Error

[tinca101]

Just starting out...tried to open the Contacts.accdb from the samples provided. Received the error as follows:-

"The table links for this sample application are not correct, and the data file could not be found in the expected default folder: C:\Access 2010 etc etc."
It then opens the expected folder for me to find the files manually. I believe the files it is looking for are Ficticious Names.xlsx and Ficticious Companies.xlsx as when I tried to open a file a subsequent error message told me it expected the 3 files (Contacts.accdb; Ficticious Names.xlsx; Ficticious Companies.xlsx) to be in the same folder.

First thing I noticed is that the downloaded files were actually called Fictitious Names.xlsx with a "t" instead of a "c". yet the error message definitely said it was looking for Ficticious Names.xlsx with a "c".

I renamed the files but it made no difference. Since I have only just downloaded the samples and unzipped it and made no other changes I assume others must have experienced this issue....or could some global setting change I have made to Access itself be responsible (though I don't see how).

Any help gratefully received. Thanks.

 

[tinca101]

Before I waste anyone's time....I have "solved" it.......translated means I actually read the appendix regarding installation of the sample files.......I'll never learn...I always dive straight in.

 

[AccessJunkie]

Hi,

I'm glad to hear you resolved the issue by looking at the Appendix for the install instructions. The reason you were hitting the issue earlier is actually because of a product bug in Access. We have VBA code in the Contacts sample application that will automatically relink all the tables to the back end database if the location is moved. The problem occurs when it hits the tblContacts one. That table has a multi-value field in it and Access fails to relink it. If you were to look at the connection properties you would have observed that all the tables up to that one got relinked OK but everything after tblContacts (including that one) failed to relink. So to workaround this product bug, just place all sample files in the appropriate directory as outlined in the Appendix.

Good luck with your studies of Access.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[Eagleclaww]

I still had that problem after following the instructions in the appendix.
SOLVE: do NOT put the database files in My Documents folder.

-I made the Microsoft Press folder directly on the C:/ drive.

The reason is that internally, the Contacts database is looking for the errant files in the "documents" folder and not "my documents", even if files are in the same folder. Just a bug I guess.