Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 15th, 2004, 10:37 PM
rjp rjp is offline
Registered User
Join Date: Aug 2004
Location: Perth, WA, Australia.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default What missing reference

I have created a quite large database over the last couple of months.
Early on i started receiving an error message on startup:

"Cannot find the file "[my database path]" (or one of its components). make sure the path and filename are correct and that all required libraries are available."

I just ignored this message because my database has never had problems with working and all the VBA code compiles just fine.

Maybe it was not a great idea to ignore this message because i'm in the polishing stage and i cant seem to get rid of this annoying start to my program (doesnt instill confidence in users). I have tried both removing and adding various references, but to no avail.
I have even tried deleting every single table,query, report and all the VBA code (modules etc) IT STILL MADE NO DIFFERENCE... aaaaahhhhhh.
Why would it complain when there is nothing left to complain about??

If anyone has idea how to fix this or what might be causing it i would be soooo GREATFUL.

Reply With Quote
  #2 (permalink)  
Old September 15th, 2004, 11:35 PM
Friend of Wrox
Join Date: Jul 2003
Location: South San Francisco, CA, USA.
Posts: 128
Thanks: 0
Thanked 1 Time in 1 Post

Probably you have created a table with link to another database table.
Then the originating table was deleted. Or another possibility is
you have a shortcut to a database that was moved to another folder.
I hope this could fix it.

Reply With Quote
  #3 (permalink)  
Old December 7th, 2004, 10:46 AM
mku mku is offline
Registered User
Join Date: Dec 2004
Location: Holon, , Israel.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

Hi, John!
I have almost the same problem - this happens when I try to access the file through a shortcut (you can see my topic created on 12/07/2004).
But what is the reason for this error msg? What's wrong? How can I get rid of it?
My users complain, they don't wanna see it. :(
Reply With Quote
  #4 (permalink)  
Old December 7th, 2004, 11:02 AM
Authorized User
Join Date: May 2004
Location: Bucharest, , Romania.
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts

Have you tried the "Linked Table Manager"?
It shows you all the linked tables with their paths. It would not be a bad ideea to update all the links.


Reply With Quote
  #5 (permalink)  
Old December 7th, 2004, 01:16 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts


   See if this helps:

From: http://support.microsoft.com/kb/166389/EN-US/

Article ID : 166389
Err Msg: Cannot Find File or One of its Components

When you double-click a file that is associated with a program, the program may start but you may receive the following error message

Cannot find file <file path> (or one of its components). Check to ensure the path and filename are correct and that all required libraries are available.

where <file path> is the path to the file being loaded. When you click OK, the file is loaded correctly.

The Use DDE setting is enabled, or the information in that section is incorrect.

To resolve this issue, follow these steps:
1. Double-click My Computer.
2. On the View menu, click Options.
3. Click the File Types tab. To modify an association, click the file type in the Registered File Types box, and then click Edit.

To determine which file type is causing the problem, use the right mouse button to click a file of the appropriate type in Windows Explorer, and then click Properties. The line titled Type lists the entry in the Registered File Types box that needs modification.
4. Click the Use DDE check box to clear it.


• Microsoft Windows 95
• Microsoft Windows NT Server 4.0 Standard Edition
• Microsoft Windows NT Workstation 4.0 Developer Edition

This may also apply to later OSs since the article was posted in 2001.

Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
missing a using directive or an assembly reference zhshqzyc ASP.NET 2.0 Basics 3 January 13th, 2008 03:50 AM
Is there some ':, missing ??? saban SQL Server ASP 1 May 28th, 2007 06:32 AM
Bogus missing reference rahzan Access VBA 8 April 11th, 2005 08:35 AM
IsBroken vs Missing Reference tlwaltz BOOK: Access 2003 VBA Programmer's Reference 1 August 5th, 2004 10:43 PM
what am i missing? m002864 Crystal Reports 0 July 6th, 2004 07:24 AM

All times are GMT -4. The time now is 09:18 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.