ilaw


I got the following error message when I tried to open a table from a FoxPro database.

"Table "name" has become corrupted. The table will need to be repaire before using again."

So, I run the command and put "Set TableValidate to 0"

However, after I got another error message after I ran the above command.

"Primary Key property in invalid, please validate database"

So, I validated the database by typing "Validate Database", but I still got the above message.

How can I solve it Please advise.





Re: Table "name" has become corrupted. The table will need to be repaire before using again.

Naomi Nosonovsky


You may try

OPEN DATABASE myDatabase EXCLUSIVE

VALIDATE DATABASE RECOVER

COMPILE DATABASE

PACK DATABASE

You may also need to use some table repair tools listed at http://fox.wikis.com/wc.dll Wiki~TableCorruptionRepairTools






Re: Table "name" has become corrupted. The table will need to be repaire before using again.

ilaw

After I entered VALIDATE DATABASE RECOVER, it poped up a message and said "Object #8(Table 'grants'); Cannot open table d:\grants.dbf. Would you like to delete this object or cancel the validation"

I don't wanna delete the table, what else can I do







Re: Table "name" has become corrupted. The table will need to be repaire before using again.

Naomi Nosonovsky

Do you have a good working copy of the database Make also a copy of this damaged database and you may have to follow the suggestion, e.g. you may need to remove this table from database and later re-add. The long names may be truncated Sad

I'm not sure what else to suggest.