>>We have problem when trying to do MODIFY DATABASE. It takes several seconds to bring the screen. Also, if we try to re-build referential integrity without packing database first we would get internal database inconsistency error. In VFP8 there were no way to fix it, in VFP9 it looks like VALIDATE DATABASE RECOVER fixed the problem. However, we tried it only once.
>
>I have 84 tables in my single dbc at the moment, and it opens immediately (vfp8) but then I don't have any code in it. We're enforcing RI through bizobjects. This may mean that there's some technical limit that you've hit (i.e. number of tables with RI) where it becomes wild.
>
>Thanks, this is a good warning.
How are you ensuring that no changes done to the tables outside the application?
If it's not broken, fix it until it is.
My Blog