>Thank you all for all your replies! Some of what I was told was new, especially, compile database, a command I have never noticed.
>
>Valid data recover doesn't pack the DBC, even if it did work in run time, it wouldn't help. But perhaps, my "wish" should be modified so there is a valid database recover pack command.
>
>I am a bit nervous about PACKing my database definition, someone had mentioned that it wasn't a good idea. But perhaps, with the compile data command, it would be safer. I'll look into that. For now, I'll re-build from scratch.

Hi Todd - I think some of what you're after is not totally possible. But for one thing, if you have the DBC open EXCL, all you have to do is quickly close it, USE it, and PACK it to achieve that part of the cleanup.

But as far as a useful automated VALI DATA RECO at runtime, I think that would be nearly impossible, since there are a variety of possible problems, some of which require human intervention and decisions to correct...