>I have what is apparently an invalid database. Among the problems, some of the tables have an "Invalid primary key property." When I try to open the table, or alter it, I get an error telling me "Primary key property is invalid; please validate database." Issuing a VALIDATE DATABASE merely lists the problems, it doesn't solve them. How can I fix the primary key problem? Also, I need to be able to do it programmatically at a client's site.
>
>Thanks,

Elyse,
Try:
close database
open database mydatabase exclusive
validate database recover

For future reference look into getting Stonefield Database Toolkit for an easy interface to handle problems like this.