ACC2000: "Couldn't Find Input Table or Query '<Name>' " Error Msg

ID: Q208621

The information in this article applies to:

Microsoft Access 2000

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you open or make a reference to a linked table in Microsoft Access, 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, do the following:

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 an object that has been deleted.

If the table of query exists, it is likely that there is a syntax or a spelling error in your reference to it. If so, correct the syntax or spelling in the reference.

When you try to open a linked table, the file containing the table isn't on the path that you specified when you linked it. If you have moved the file, you can use the Linked Table Manager to update the link information.

Additional query words: prb


Keywords          : kberrmsg kbusage kbdta GnlOthr 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 13, 1999