Access app 'Invalid field name' error when using Where clause

  • Article

Issue:

You may experience the following error when using macros containing Where clauses within an Access app:

Access Services

Invalid field name ‘<tableName>.<fieldName>’

Cause:

The table name specified as criteria within the macro Where clause has become case sensitive and does not match the case sensitivity of the table name displayed in the Access app’s Navigation pane. For instance, the Where clause may be: "Where = ([tasks.status] = ‘Active’)" and the table name in the Navigation Pane appears as "Tasks".

Work Around:

Change the table name in the Where clause to the same case as that of the table name in the Navigation Pane.

Status:

The developers have reported that this issue should now be resolved for all tenants.