ADO Help Required

[BrendanK]

I'm most of the way through writing a program which syncronises two ODBC databases (Ensures the structure of the target database contains the structure of the first)

If I were doing this in DAO I'd be fine, but am having troubles creating tables/fields in the target DB using ADO.

I've realised that one must use ADOX (extended) to programatically create structure in an ODBC database, but after I create the Table object and append all my fields (columns) to it, as I append it to the tables collection of my target database, It tells me

"Object or provider is not capable of performing the requested operation".

The line this error is generated from is
"TargetCAT.Tables.Append NewTbl", where targetCAT is a category object.

The provider I'm using is "MSDASQL", the generic ODBC driver. Can I not create structure using this provider?

Any help appreciated

Thanks

Brendan