This is here already Just modify the database
Click on the menu option Database; Cleanup Database
Ron
>>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