ACC2000: Error Refreshing Text File with Linked Table Manager
Article ID: 199251
Article Last Modified on 6/24/2004
APPLIES TO
- Microsoft Access 2000 Standard Edition
This article was previously published under Q199251
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
When you create a link to a text file from Microsoft Access and then
move the text file to another folder, you may receive the following error
message when you try to use the Linked Table Manager to refresh the link:
The Microsoft Jet database engine could not find the object <file name>. Make sure the object exists and that you spell its name and the path name correctly.
CAUSE
A specification is created when you create a link to a text file. If you
quit Microsoft Access, move the text file to another folder, and then
restart Microsoft Access, the specification no longer works because the
path to the text file has changed.
RESOLUTION
Remove the link to the text file. Then, re-create the link to the text file
in its new location.
REFERENCES
For more information about linking text files, click Microsoft Access Help on the Help menu, type link a delimited or fixed-width text file in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Additional query words: prb
Keywords: kberrmsg kbprb KB199251