compact/repair on Open?

S

Sam Luke

I wish to compact the database the moment it is launched. I tried below 2
options
a) Through the code level by using the accDefaultDatabase
b) Call the /compact command in a bat file before executing the access
database.

Is there any better solution available?
 
S

S Panja

Why not use the default Compact On Close? It leaves you with a compacted
database for use, which is what you are aiming by attempting Compact On Open.
 
Top