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