>I have a database in VFP 8.0 that gets corrupted consistently when I run the Referential Integrity builder. I get a message after running this that says '.DBC Internal Consistency error'. First, does anybody know why this would happen? And second, how can I recover my database?
>
>When trying to open the database after this, a message states to delete and re-create the database index. Of course, I try this by deleting the 'dcx' file but can't recreate it.
>
>(I have a backup but I would like to know why this is happening so I can prevent it from happening again, and just as important, maybe find out I have a problem in my database that may cause further problems down the line.)
>
>Thanks for any help.



I am not sure if I have an exact match on your problem, but last year we found a program that would routinely add / drop tables many times a day. ( programmer thought it was the only way to get long file names -- when a cursor created with the DBC open would have worked ). We changed the Add / drop to create cursor and our DBC corruption disappeared.