You are currently offline, waiting for your internet to reconnect

Error message when you use Access: "The Microsoft Jet database engine cannot find the input table or query '<name>'" or "The record source '<name>' specified on this form or report does not exist"

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q287696
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.accdb and .mdb).
For a Microsoft Access 2000 version of this article, see 208621.
For a Microsoft 97 version of this article, see 141616.
SYMPTOMS
When you open or make a reference to a linked table in Microsoft Access, you may receive one of the following error messages:
Error message 1
The Microsoft Jet database engine cannot find the input table or query '<name>'. Make sure it exists and that its name is spelled correctly.
Error message 2
The record source '<name>' specified on this form or report does not exist.
Error message 3
  • In Microsoft Access 2002
    • Microsoft Access can't find the object '<name>.'
    • Run-time error '7874': Microsoft Access can't find the object '<name>.'
  • In Microsoft Office Access 2003 and in Microsoft Office Access 2007
    • Microsoft Office Access can't find the object '<name>.'
    • Run-time error '7874': Microsoft Office Access can't find the object '<name>.'
CAUSE
You may receive this error message if Access cannot find the table or the query in the database, if a link points to an external file that does not exist, or if the external file has been moved to a new location. This error can also occur if a deleted or renamed table or query is referenced on the Lookup tab of another table.
RESOLUTION
To troubleshoot this behavior, do the following:
  • Check to ensure that the table or query exists. If it does not exist, you can remove all references to it, or if it is a missing table, reimport or relink the table. If it is a missing query, reimport or re-create the query. Often the RecordSource property of a form or a report contains a reference to a table or a query whose name has changed or which has been deleted.
  • If the table or query exists, it is likely that there is a syntax error or a spelling error in the reference to it. If so, correct the syntax error or spelling error in the reference.
  • When you try to open a linked table, the source table may not be in the path that you specified when it was first linked. If you have moved the file, you can use the Linked Table Manager to update the link information.
can't prb could not can cannot ACC2002 reviewdocid ACC2007
Properties

Article ID: 287696 - Last Review: 03/27/2007 17:12:17 - Revision: 7.0

Microsoft Office Access 2007, Microsoft Office Access 2003, Microsoft Access 2002 Standard Edition

  • kberrmsg kbprb kbusage KB287696
Feedback
'" error message. Includes troubleshooting steps. " />
'" error message. Includes troubleshooting steps. " />
/html>