I am accessing a FoxPro Free Table from Access by linking to it using ODBC. In order to be able to update the FoxPro table, I need to define a unique index on the FoxPro table when I link to it.
When I do this using File/Get External Data/Link Tables it works OK.
However, I am having trouble coding it in VBA. I create the index and append it to the tabledef, however, when I append the tabledef I get Error 3039 "Couldn't create index; too many indexes already defined".
Is this because I cannot define and index on a linked table? If this is so, why is it possible to do the same operation using File/Get External Data/Link tables with no problem? How do I get round this?
Thanks, in anticipation,
Angela
When I do this using File/Get External Data/Link Tables it works OK.
However, I am having trouble coding it in VBA. I create the index and append it to the tabledef, however, when I append the tabledef I get Error 3039 "Couldn't create index; too many indexes already defined".
Is this because I cannot define and index on a linked table? If this is so, why is it possible to do the same operation using File/Get External Data/Link tables with no problem? How do I get round this?
Thanks, in anticipation,
Angela
