ADO

[taccea]

Sorry, I forgot to send it here too....

I am importing a SQL2000 table using the DoCmd command, the TransferDatabase
method and ODBC.
Using Access2000.
Table transferrs OK, except when I try to create an
index using ADO, I cannot.
But if I simply copy the table inside Access then
I can run the same ADO create index code against
it and it works fine.

If anyone knows what I can do to able to access this table let me know.

Thanks

Taccea