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

• 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.

MORE INFORMATION

Steps to Reproduce Problem

1. Open the sample database NWIND.MDB and then open the Category List query in Design view.

2. Add the following field to the query:

         Field: Expr1: Len([Category Name])
   

3. Run the query.

4. Minimize Microsoft Access.

5. Open a second instance of Microsoft Access.

6. Close the second instance of Microsoft Access.

7. Restore the first instance of Microsoft Access. Note that the "#Error" message now appears in the Expr1 field.

REFERENCES

For more information about the "#Error" and "#Name" error messages, search for "error values" then "Error Values" using the Microsoft Access Help menu.