DoCmd.TrasferDatabase adn ado indexing

T

taccea

Hello,

I have imported via ODBC 3 tables into Access2000 from SQL2000.

When I try to index on of the tables using ADO it erros out, acting like if
after the import the table remaind open.
If I make a copy of the table then run the same indexing code it works on
the copy, but not on the original table
brought in by the ODBC,
How do I allow for writing to this table after the import?

taccea
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DoCmd.TransferDataBase command 3
ADO 0
Text Field Filter vs. Number Field Filter on same table 0
Linked Table Manager works one at a time 4
Problem with DAO Vs ADO 9
Access Index 4
ADO and Indexes 2
Damaged Outlook 2010 file prevents indexing. Am I doing the right repairs? 0

Top