You may try to use RECOVERY option of VALIDATE DATABASE command (database must be opened exclusively). I can not guarantee, though, it would help.
>Dear Friends
>
>Due to power failure, the database get corrupted. I issue the
>VALID DATABASE command.
>
>It give message :
>
>The fields in the table 'tablename' didnot match the entries in
>the database.
>
>I corrected the problem by issuing following command
>in command box:
> OPEN DATABASE 'DatabaseName'
> MODIFY DATABASE
>
> Then remove the table from the database and again add the
> table into the database.
>
>Is there any other way to solve the problem ie by issuing command only?
>
>Thanking you
>Yours truely
>Aritra Roychoudhury
If it's not broken, fix it until it is.
My Blog