Am Samstag, den 25.08.2007, 11:34 -0400 schrieb andrew: > > So you can do so either in the SQL window or in a script with > > > > oStatement.ExecuteUpdate( "CHECKPOINT DEFRAG" ) > > > > Drew
> 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. Not wanting to insult anybody, but: Did you mke sure you "commit"ed the command explicitly or the "AutoCommit"-property is set to true? HTH, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]