Corrupt Project?

gregjohn · Apr 13, 2006

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 · Apr 13, 2006

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 · Apr 13, 2006

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 · Apr 13, 2006

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 · Apr 13, 2006

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Corrupt Project?

gregjohn

Technical User

alvechurchdata

Programmer

robsuttonjr

MIS

gregjohn

Technical User

Mike Lewis

Programmer

Similar threads

Part and Inventory Search

Sponsor