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.

>>This is here already Just modify the database
>>
>>Click on the menu option Database; Cleanup Database
>>
>>Ron
>>
>
>You missed the point of the thread... which was wanting to do a 'Clean Up Database' from code/runtime... There is no direct command to do it.
>
>BOb
>
>
>>>>I would like to see the "clean up database" option of the database designer be available programmatically. That way, in my big "Fix Anything that might be wrong" maintance routine, I could do a clean up!
>>>
>>>Isn't clean up database nothing more than a pack of the DBC? You can do this programatically...
>>>
>>>close database MyDataBase
>>>use MyDataBase.DBC excl
>>>pack
>>>use
>>>open database MyDataBase
>>>
>>>BOb