Go to Google Groups Home    microsoft.public.access
Re: Why does system crash when Compact and Repair Database is used?

Danny J. Lesandrini <dlesandr...@hotmail.com>

I know this one ... but there is no answer.  It's a bug.

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?