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

R J Kershaw

View profile

More options Jan 24 2006, 5:57 am

Newsgroups: microsoft.public.access

From: "R J Kershaw" <RJKers...@discussions.microsoft.com>

Date: Mon, 23 Jan 2006 10:57:02 -0800

Local: Tues, Jan 24 2006 5:57 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
  

Many thanks for your kind assistance.
Bob K
p.s. this never happened in years with Access97 & Windows98!

"Danny J. Lesandrini" wrote:
> 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