andrew wrote:
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]
Well, it turns out with a little further testing that this is not
exactly the case.
Executing CHECKPOINT DEFRAG from the SQL window will indeed shrink the
size of the odb file,
Doing so with in a script with
oStatement.ExecuteUpdate( "CHECKPOINT DEFRAG" )
does not. It runs to completion, but the file size is not changed.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
