Bypass Compact on Close

G

Guest

Is there a way to bypass the compact on close feature, similar to holding the
ctrl key down, so an autoexec macro doesn't run?

Robin
 
R

Roger Carlson

Go to Tools > Options... then choose the General tab. Uncheck the box for
Compact on Close. This will turn it off for All databases, but this is a
good thing. Compact on Close does more harm than good. If you really want
a feature like this, you can write one yourself that is much safer and gives
you an automatic backup.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CompactDatabase.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 

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

Disabling "Compact on Close" During Testing 1
Bypass Start Up Switchbaord 9
Shift ByPass 4
disable esc key on compact and repair 1
How to change owner of macro object 3
Compact Database 3
Compact On Close 3
Compact and Repair Using Scheduled Tasks 2

Top