>From time to time I will recieve the error "Internal Consistency Error". This does not seem to be associated with the indexes in any way. The entire table itself does not become corrupted, only a small subset of the entire table. The table does belong to a DBC container.
>If you copy out the subset(e.g. All parts that start with "P") to a temp.txt sdf file, delete out the subset from the table, pack the table, and then append back in the records from the txt file the error goes away. I do not get it a lot, but probably 5 or six times out of the year it shows up.
>
>Any ideas what causes this, and better yet when it happens, how to fix it. There are about 100 users in and out of the system throughout the day.
In FP2.X this was usually associated with a corrupt FOXUSER.DBF. The solution was to delete it and then restart the application.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer