How can i compact & repair database with macros??

  • Thread starter Thread starter jack
  • Start date Start date
There are lots of things that macros just can't do.

Even using VBA, you can't compact the currently-open database, although you
can compact another database using the CompactDatabase method.
 
Jack,
Under the tools menu chhose options...then choose the
general tab... on there you will see towards the lower
left you will see the option to COMPACT ON CLOSE...
that should do it.

JI
 
Hi!

I just posted this question today... Did you ever find a
resolution? If so, would you please share your findings
w/me? Thanx!

m
 
Back
Top