Microsoft KB Archive/114730

{|
 * width="100%"|

ACC1x: "#Error" Message with Second Instance of Microsoft Access

 * }

Q114730

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SYMPTOMS
In Microsoft Access, you can create and run a query with an expression. However, if that expression uses an Access Basic function, a second instance of Microsoft Access will cause a "#Error" or "#Name" error message to appear in the expression field in any query, form, or report that references that field.

RESOLUTION
Close the query, form, or report and then reopen it to refresh the value. Pressing F9 will not refresh the value.

STATUS
This problem no longer occurs in Microsoft Access version 2.0.

Steps to Reproduce Problem
 Open the sample database NWIND.MDB and then open the Category List query in Design view.  Add the following field to the query:

     Field: Expr1: Len([Category Name])  Run the query. Minimize Microsoft Access. Open a second instance of Microsoft Access. Close the second instance of Microsoft Access. Restore the first instance of Microsoft Access. Note that the "#Error" message now appears in the Expr1 field.</ol>