How can i compact & repair database with macros??

D

Douglas J. Steele

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.
 
J

John I

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
 
M

m wark

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access error 3059 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
"Compile error in table level validation expression " after format 0
How can I install Publisher in 365 Enterprise? 1
I can create Publisher documents, but I can not open / read them. 0
Need Help with Macro Security 1
Coding a macro to compact and repair several external databases 1
Compact and Repair 12

Top