As you've discovered, spaces in names cause problems.
The ideal solution would be to remove them! Assuming you've gone too far to do this without loads of work, just wrap the field names in square brackets.
SELECT [table 1].[field 1]
FROM [table 1]
Braxis Computer Services Ltd.