CreateTableDef equivalent in ADO

[DeanWilliams]

Hi,

Is there an equivalent method for creating tables in ADO to the DAO CreateTableDef method?

I want to create a temporary table that has an AutoNumber ID field. This table would then be populated by a form and the AutoNumbers handled automatically.

Do I need to use SQL commands, and what's the easiest way to handle the AutoNumber Field?

Hope someone can help.

Thanks in advance.

Dean

 

[SBendBuckeye]

Hello Dean,

I think the last entry of this thread is what you are seeking: thread705-799692. Good Luck!

Have a great day!

j2consulting@yahoo.com