When I try to create a view on an access table named "Language Codes Map" the view blows, telling me that its an invalid name.

I am ok with the shorter names (the ones that don't have spaces in them)

I am trying to automate making views out of all the tables in the database. I do it with sqltables() and then run thru the list of tables and make a view from the table.

Can anyone advise about how to macro expand the table name so that access ODBC driver likes it? I tried &tablename and (tablename) &tablename looks correct, but it complains "Error in from clause"

when I try (tablename) it tells me can't find table tablename.

Thanks for some help!