Corrupt Project?

[gregjohn]

I was in the process of rebuilding my project when I had a hardware failure.

The project opened, but for the key database, upon trying to drill down says, "no drilldown information is available for database name. Database may be invalid. Upon clicking the validate button, I get the error message "index does not match table. Delete index file and recreate".

Problem is I have no idea which index file it is talking about and I have a lot of different index files. Is there any way of finding the corrupt index files or any other suggestions?

Thanks

 

[alvechurchdata]

Is it the project or the database that is corrupt? Can you use the Open Database command from the Command Window?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[robsuttonjr]

Try opening each table in your database outside of the project seperately until you get the index does not match error. The table with the missing index will need to have the .cdx file deleted and recreated.

Regards,

Rob

 

[gregjohn]

I think the database is corrupt. I tried the open database from the command prompt and received the same "index does not match the table". Also, I tried to open a table and received the error "the database for file .. could not be opened. Would you like to try and locate or delete the link."

I select the correct database and it just repeats the same message.

 

[Mike Lewis]

Gregjohn,

The problem probably lies with the DCX file. Either it's missing, or it has a zero length.

You could try doing OPEN DATABASE ... VALIDATE at the command prompt, but I suspect you'll just see the same message. Ideally, you will have a backup of the DCX. If so, be sure also to restore the corresponding DBC and DCT. You won't have lost any of your data, but you might have to restore any of the database properties that you created after you made the backup.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk