I am trying to link foxpro 2.6 free tables and their indexes in msaccess through code. (.dbf file and it's associated .cdx file) I'm able to link them using dbase IV however, the indexes will not update when deleting or adding records.
I have tried to create an inf file which points to it's cdx index file but it errors out giving me 'index file not found'.
I have also tried vfpoledb to link them but I can't get around the prompt to select the unique record identifier. I need to establish this to edit the table.
Does anyone know if I can set the index fields through a connection string?
Thanks for your help!
I have tried to create an inf file which points to it's cdx index file but it errors out giving me 'index file not found'.
I have also tried vfpoledb to link them but I can't get around the prompt to select the unique record identifier. I need to establish this to edit the table.
Does anyone know if I can set the index fields through a connection string?
Thanks for your help!