>I am working remotely via Laplink onto a host that is running a VFP6 exe. They were getting internal consistency errors when shipping from the app. I decided to rebuild the cdxs for the 2 invoice tables. Well...I opened the detail table and delete tag all. Then rebuilt the tags with the index on commands. I made one of the indexes a primary key as it was before by using the Alter table command. That worked great.
>
>Next I tried the same on the header file. Can't get it to open "Primary key property is invalid. Please validate database". When I validate the database, it essentially tells me the same thing and I still can't get it.
>
>Unfortunately, they only have the exe (although it does have an option to use the command line but I can't modi the database from there.
>
>I downloaded it all and can modi the database but can't get in to the header table (same error). I opened the dbc and deleted all recs for the header table. Modi the database again and it is gone but I can't add it back because it says it is already part of the dbc.
>
>Any help would be great!!!
>
>Sally
Sally,
You would lose extended field properties like caption, format, inputmask, fieldrule etc but you could do this (clearing out dbc info you already should have lost these). Put the table to a different directory, close database if open and open the table exclusive. It would say cannot find dbc, delete backlink info ? Answer yes and free the table. Get back to its original directory and execute :
open data myDatabase.dbc
add table myTable.dbf
Cetin