Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you use Access 2000: "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"

Error message when you use Access 2000: "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"

View products that this article applies to.

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

For a Microsoft Access 2002 version of this article, see 287696� (http://support.microsoft.com/kb/287696/ ) .
For a Microsoft Access 2002 version of this article, see 287696� (http://support.microsoft.com/kb/287696/ ) .

↑ Back to the top

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
Microsoft Access can't find the object '<name>.'
Error message 4
Run-time error '7874': Microsoft Access can't find the object '<name>.'

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB208621, kbusage, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 208621
Revision : 3
Created on : 6/20/2006
Published on : 6/20/2006
Exists online : False
Views : 425