How To Fix Index Corruption at Run Time with Visual FoxPro
Article ID: 168762
Article Last Modified on 7/1/2004
APPLIES TO
- Microsoft Visual FoxPro 3.0b Standard Edition
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 5.0a
- Microsoft Visual FoxPro 6.0 Professional Edition
This article was previously published under Q168762
SUMMARY
When index corruption happens at run time under the Foxpro 2.0, 2.5, or 2.6
platforms, you can easily erase the IDX/CDX files and re-create them. But
under the Visual FoxPro environment, once the table is bound to a database
and it has Primary index, you cannot erase the CDX file because it
generates "Primary key property is invalid, please validate database" error
when you try to open the table again in the database.
Re-creating the index on an erased CDX file that only has regular,
candidate or unique index generates the following error:
Invalid database - please validate database
Keywords: kberrmsg kbhowto kbdatabase KB168762