Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening database
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00329695
Message ID:
00329707
Views:
26
>does anyone know how I can get my database open when it gives me the following error when I try to open it: "Index does not match the table. Delete the index file and re-create the index."
>I went to msdn to try and find some insight but it says:
>"A damaged structure within an index file has been detected.
>Delete the index file (.CDX or .IDX) and recreate it."
>This doesn't help me any because it is basically rewording the error message.

Are you really talking about OPEN DATABASE and not a DBF?

open database mydbc exclusive
validate database recover

If that works, start opening all the tables. The one that give the error is the one you need to delete the CDX for. If it is the database you can not open, delete the MyDBC.DCX file. Then open the database exclusively again and do another validate database recover to rebuild the DBC's index file.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform