Microsoft KB Archive/932994

= You receive an error message when you run a query that includes a field name that begins with a double-byte Arabic number in Access 2007 or Access 2003 =

Article ID: 932994

Article Last Modified on 7/10/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003

-



SYMPTOMS
In Microsoft Office Access 2007 or in Microsoft Office Access 2003, you receive an error message when you run a query that has a field name. This problem occurs if the field name begins with a double-byte Arabic number.

For example, if the field name contains two or more characters, such as &quot;１Month&quot;, you receive the following error message:

Syntax error in query expression ' Table Name .１Month': Missing operator.

If the field name only contains one character, such as &quot;1&quot;, you receive the following error message:

Invalid use of '.', '!', or '' in query expression ' Table Name. '.

Note In Access 2003, this issue only occurs when you run the query on a Windows Vista-based computer.



RESOLUTION
To resolve this problem, enclose the field name in single-byte square brackets ([ ]). For example, change the field name from １Month to [１Month].



Steps to reproduce the problem

 * 1) In Access, create a table.
 * 2) Define a field by using a name that begins with a double-byte Arabic number.
 * 3) Create a query that refers to the field in the table.
 * 4) Run the query.

Keywords: kberrmsg kbtshoot kbprb kbexpertiseinter KB932994

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.