ACC: "Couldn't Find Input Table or Query '<Name>' " Error Message
Article ID: 141616
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q141616
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you open or make a reference to a linked table in Microsoft Access 7.0
or 97, you may receive the following error message:
Couldn't find input table or query '<Name>'
-or-
Couldn't find file '<pathname>\<filename>'
CAUSE
Microsoft Access could not find the linked table, or the external .mdb file
does not exist anymore or is in a different location. This error also
occurs when a deleted or renamed table is referenced on the Autolookup tab
in Design view of a table.
RESOLUTION
To troubleshoot this situation, follow these steps:
- Check to ensure that the table or query exists. If it does not exist,
you must remove all references to it from your application. Often, the
RecordSource property of a form or report contains a reference to an
object whose name has changed or has been deleted.
- If the table of query exists, then it is likely that there is a syntax
or spelling error in your reference to it.
- When you try to open a linked table, the file containing the table
isn't on the path you specified when you linked it. If you have moved
the file, you can use the Linked Table Manager to update the link
information.
NOTE: Linked tables were referred to as Attached tables in Microsoft Access
2.0 or earlier.
Additional query words: couldn t
Keywords: kberrmsg kbprb kbusage KB141616