General information
Category:
Database DAO/RDO/ODBC/ADO
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only