Article ID: 287696 - View products that this article applies to.
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
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
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.
To troubleshoot this behavior, do the following: