>I have a customer running an accounting system writted in VFP 5.0. I am having problem opening a table. Each time I trr to open the table I get the message "invalid primary key please validate database". I have tried to validate the database but I does not correct the problem. The user does not have VFP loaded. I am not sure what to do next. Is there a way I can edit the file on site? Is there a way I can validate the database and recover? Should I just dial in grab the data and fix it at my site?
Jeff,
This line might fix it:
Use MyDatabase Exclusive
Validate Database Recover
Is it possible that there are duplicate primary keys existing in the table? Run a Select to determine if there are and manually adjust them. Make sure you check any dependencies/relationships for other tables also.
Worse case, zip the database/table and send to
renoir@bellsouth.net and I'll take a look at it.
Renoir