compact database

[damrus]

Hoping that someone help me...

I would like to compact database in the middle of running a code in VBA.
Is it possible to compact dtb using VBA under the same Access database?


For example:
sub t()

For i = 1 To 999
DoCmd.RunSQL "blabla"
Next

' ! here I would like to put a code to compact the database

For i = 1000 To 9999
DoCmd.RunSQL "blabla"
Next
End sub

 

[lameid]

To compact the database you have open, no you would not be able to resume. You could store a value or procedures in a table snd conditionally run them when your database re-opens. You could however compact a backend, if there are no connections opened (no locking file).

Anyway the things to look at to compact are... The first allows you to specify a password and the second does not. I would go with the second if there is no password.

DBengine.Compactdatase
Application.CompactRepair

 

[missinglinq]

You should also know that many believe Compacting to be a cause of corruption, and hence a Backup Copy of the Database should be always be made before Compacting.

The Missinglinq

Richmond, Virginia

The Devil's in the Details!