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:
PS. The field names cannot be changed.Code:UPDATE Sample SET WHERE Sample.[120 XXX]="AAA"