Question:
I have an established Access v2.0 database with fields intables named “Circuit ID”, for example. How can I use VB v3.0 to query this database without changing all references to that field to “Circuit_ID”?
Answer:
Just enclose the field name in square brackets. Doing that will allow you to use spaces and other characters in the field names.