Hi John.
>Physically delete the CDX file then open the table (you'll get a structural index not found error if it's the structural cdx...ignore it) -- then recreate the indexes either throught a PRG script or manually.
That won't necessarily work -- if the table belongs to a database and you've defined a primary key for the table, VFP refuses to open the table if the index is missing or damaged. The only solution in that case is to VALIDATE DATABASE RECOVER and tell VFP to remove the primary key for the table (as well as the other indexes), then recreate them. One complication: VALIDATE DATABASE RECOVER won't work in a run-time environment, so you can't do this at a client site.
Doug
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only