- 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, Microsoft Office Access 2007, and Microsoft Office Access 2010
- Microsoft Office Access can't find the object '<name>.'
- Run-time error '7874': Microsoft Office Access can't find the object '<name>.'
- 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.
Article ID: 287696 - Last Review: Jan 7, 2017 - Revision: 1