Can't you reference your Access tables (if they have spaces) in SQL by placing brackets [] around the table name? I think most DBMS's allow you to have special table names, but you just have to surround them with something. For example in mySQL, I know that you have to surround special table names with the ` (backtick) character.
