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.

Rowe,
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.
John

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. :(
Marina.

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.

Mihai

Hi,

   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

SYMPTOMS
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.

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

RESOLUTION
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.

--------------------------------------------------

APPLIES TO
• 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.



mmcdonal