ADO: qualify table name if open connection

[jspeirer]

I am creating a UI front end for our users to create databases, complete with tables and indexes, for their clients. After I open the connection, I create my database. If I don't close down the connection, when I create my table, do I have to qualify it with the database name. Or, will the program know where to create the table at?

[Derek Stone]

Working with multiple databases usually means executing the USE directive:

 

USE databasename
CREATE TABLE tablename ...

 

Keep in mind that proper security should be in place so one user cannot access another user's database.

[jspeirer]

Thanks, I'll give this a try