Solved: create table vs createtabledef

[philfer]

Hello,

What is the difference between the two above?

Thanks
Phil

[CreganTur]

CreateTableDef creates a TableDef object that represents a table or a linked table in a Microsoft Jet workspace. It's generally used to create a table via ADO or DAO connections. Since you're creating a new TableDef object, you can use this to create a linked table, or you can use it to create a new table in your database.

CreateTable is a constant of DDL(Data Definition Language), which is a part of SQL. The structure looks very much like a SQL string, and you can use an ADO or DAO EXECUTE method to create the table with it. This method only allows you to create a new table.

There may be many other differences I'm not aware of.

HTH:thumb