Database = MSAccess
Field Name = 120 XXX

Problem - The SQL statement generated by the builder does not enclose the field names in brackets. This then raises an exception with "error in update statement". BTW, same problem with the insert statement.

So the question is: How can I force the builder to place brackets around the field names so that I have a statement like this:

Code:
UPDATE Sample SET 
WHERE Sample.[120 XXX]="AAA"
PS. The field names cannot be changed.