You have a field naming problem. A lot of DBMS packages support field names with hyphens, some do not. Have you tried bracket notation? [my-field] - this gets around a lot of problems with funny characters in field names.

The VB IDE is what is adding the spaces around the hyphen. YOu can use another editor, then cut and paste the code into the VB IDE. As long as the IDE editro diesn't touch it, the spaces will not be there