Compact Database Macro

S

Scott

I want to create a macro that upon closing the database
will automatically compact the database. Can anyone help?

Thanks!
 
N

Nikos Yannacopoulos

Scott,

If you have Access 2000 or later, you don't need a macro for that, it's a
built-in feature! All you need to do is go Tools > Options, select tab
General and tick Compact On Close.

HTH,
Nikos
 

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

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Need Help with Macro Security 1
Access error 3059 0
"Compile error in table level validation expression " after format 0
Coding a macro to compact and repair several external databases 1
Error-17099 SMTP Relay Error Problem Entourage 2004 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How do I clear a form? 0

Top