The simplest and best solution is to turn off Compact on Close. Databases
just don't need to be compacted all that often. Do it manually once a month
or so.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"GEORGIA" wrote:
> is there anyway to disable esc key so that person can't cancel the compact
> and repair on database close?
> Thanks!