The other day the question came up about recovering space from deleted
records in a Base ( embedded ) database.
I mentioned using the command
SHUTDOWN COMPACT
in the SQL window, and that you would need to close and reopen the Base
file.
You can also use this command
CHECKPOINT DEFRAG
without the need to close and reopen the Base file then.
So you can do so either in the SQL window or in a script with
oStatement.ExecuteUpdate( "CHECKPOINT DEFRAG" )
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
