Reindex FosPro Table using ADO object in Excel VBA

04-20-2004, 10:56 AM
I am using an ADO object to access a FoxPro table (DBF file).

The problem is when I insert new records in the table, the indexs (CDX File) of the table are not updated. I expect that I must recreate or rebuild the indexs but neither DROP INDEX and CREATE INDEX queries work.

Any advice??

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum