Why does system crash when Compact and Repair Database is used? - microsoft.public.access

Message from discussion Why does system crash when Compact and Repair Database is used?

Danny J. Lesandrini

View profile

More options Jan 23 2006, 8:03 am

Newsgroups: microsoft.public.access

From: "Danny J. Lesandrini" <dlesandr...@hotmail.com>

Date: Sun, 22 Jan 2006 14:03:09 -0700

Local: Mon, Jan 23 2006 8:03 am

Subject: Re: Why does system crash when Compact and Repair Database is used?

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

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?

Reply to author Forward