how about opening the database without index
set safety off
index on .............to
set safety on
you create a new index without any problem.
you can link it to the errormessage of corrupt index
On Tue, 9 Mar 1999 12:08:28 +0100, "Anders Altberg"
>Keep a second index file Reserve.CDX at hand. It can be created against an
>empty table but it contains exactly the same index keys and indextypes.
>Erase the production cdx that is damaged and COPY FILE the backup index file
>to take its place. You should now be able to open the table.
>> When I encounter the problem stated in the title, I cannot open
>> So, I delete the .cdx file. Then, however, VFP complained that
>>'Primary property is invalid'. Then the case becomes:
>> Without opening the table, I cannot drop the primary key.
>> Without dropping the primary key I cannot delete the .cdx file.
>> Without deleting the .cdx file, I cannot open the table!
>> What a deadlock!!!! :~
>> Anybody can help me?
>>Thx for any help
06900 Yan, Kedah MALAYSIA
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
-----END PGP SIGNATURE-----