> I'm going to bet it only happens after you've had a code window open.
> Try this:  before attempting to compact, close all code windows and
> save.  (Windows | Close All Windows  and  File | Save)

> Now close the Visual basic IDE and compact.  In my experience, the
> problem with error on Compact goes away.

> I have observed this and a good friend who is an Access guru has
> reproduced it.  It's a bug.
> --

> Danny J. Lesandrini
> dlesandr...@hotmail.com
> http://amazecreations.com/datafast/

> "R J Kershaw" <R J Kers...@discussions.microsoft.com> wrote ...
> > In Access 2003 the command 'Compact and Repair Database' causes the system
> > (Windows XP Professional) to crash, with an error message saying it has to
> > close.
> > Why is this and what do I have to do to stop it?