>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