Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

The Microsoft Access database engine does not recognize <name> as a valid field name or expression. (Error 3070)

The specified name is not a recognized field name or a valid expression. In a query, this error can occur if you enter a name that improperly refers to a database, table, or field.

Possible causes with Microsoft Access:

  • You have a parameter in a crosstab query or in a query that a crosstab query or chart is based on, and the parameter data type is not explicitly specified in the Query Parameters dialog box. To solve the problem:

    • In the query that contains the parameter, specify the parameter and its data type in the Query Parameters dialog box. And;
    • Set the ColumnHeadings property for the query that contains the parameter.
  • In any type of query, you have improperly referred to a database, table, or field. For example, this error can occur if you refer to a field named Salary in an expression, but you misspell the field name, such as
    [Sallary]*1.1
    .


Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft. All rights reserved.