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?
Path: g2news1.google.com!news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Sun, 22 Jan 2006 15:03:23 -0600
From: "Danny J. Lesandrini" <dlesandr...@hotmail.com>
Newsgroups: microsoft.public.access
References: <B61B1879-42EA-4BDD-9514-DA1B2ED18A0D@microsoft.com>
Subject: Re: Why does system crash when Compact and Repair Database is used?
Date: Sun, 22 Jan 2006 14:03:09 -0700
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
Message-ID: <FZCdnW2KPZeBbk7eRVn-uQ@giganews.com>
Lines: 26
X-Trace: sv3-D3ertUhs33uNVNtBb4Vsw5J7rFIbpSy0YqWbtBgQ9l5EJigDAWOhMsxlQrYiZBBL8VtVy+seZZtCPw6!Gsa+sKuFmubIK+cUwDJkVHSTtiz5ZKHTS5QSyEBi9DMLaIur7U2ZIM7Uw1UXzQ==
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.32

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?