>Hi,
>
>In my application I must create a temporary table using ADO. The backend database is Access just now but this is changeable. The name of the temporary table depends on the user name. The user name can contain a space and so when I create the table in VB I have something like:
>
>CREATE TABLE TMP TABLE (CODE C(8))
>
>This is not allowed because of the space character. I have tried to use quotes and square brackets around the name. Is it possible to create table names with spaces using ADO? I know I can do it within Access itself.
>
>Pete

The brackets should work. I think the problem is in the field type, I tested with [tmp table] (code text(8)) and it works. I used the connection object execute method, but you could create it with ADOX too.