Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Error message in Access 2007 when you try to open a table or a query in design mode in a database that is from an earlier version of Access: "The expression you entered refers to an object that is closed or doesn't exist"
Article ID: 926700 - View products that this article applies to.
You open a database that is from an earlier version of Microsoft Access in Microsoft Office Access 2007. When you try to open a table or a query in design mode, you receive the following error message:
Microsoft Office Access
The expression On Click you entered as the event property setting produced the following error:
The expression you entered refers to an object that is closed or doesn't exist.
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
* There may have been an error evaluation the function, event, or macro.
This issue may occur when a table or a query has the same name as a form or a report in the Access 2007 database.
To resolve this issue, rename the form or the report so that it differs from the name of the table or the query.
Caution Name AutoCorrect fixes most issues that occur when you rename any forms, reports, tables, or queries. However, Name AutoCorrect does not repair tables, queries, or field name changes in macros or in code. Also, Name AutoCorrect does not track changes to form, report, or control names. You may have to fix some references manually. Therefore, make sure that you make a backup copy of the database before you make any changes.
To rename the form or the report in the database, follow these steps: