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
Thread-Topic: Why does system crash when Compact and Repair Database is used
thread-index: AcYgT+l84EO8D2EKTfeyr6zfuG9OaQ==
X-WBNR-Posting-Host: 195.93.21.100
From: "=?Utf-8?B?UiBKIEtlcnNoYXc=?=" <RJKers...@discussions.microsoft.com>
References:  <B61B1879-42EA-4BDD-9514-DA1B2ED18A0D@microsoft.com> <eOEJov6HGHA.240@TK2MSFTNGP11.phx.gbl>
Subject: Re: Why does system crash when Compact and Repair Database is used
Date: Mon, 23 Jan 2006 11:05:02 -0800
Lines: 39
Message-ID: <1B4D4A57-6577-4563-8B8B-8AFA338008C8@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.access
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: g2news1.google.com!news2.google.com!news3.google.com!newshub.sdsu.edu!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl

Thanks for that, Albert.
I now have a number of things to try along similar themes.
One observation: there is apparently no corruption or data loss taking place 
and the filesize indicates that at least some compaction is happening.
The mdb type is 2003, the default for Access2003.
Best regards,
Bob K

"Albert D.Kallal" wrote:

> There has been a few posts that suggest that having code windows open can 
> case this..
> 
> Try he following:
> 
> exit the application
> 
> re-enter the application (hold down the shift key if you have any startup 
> forms..or any startup code that runs when the application loads).
> 
> now try a compact and repair. If this don't work..then I would suggest that 
> you create a new blank database..and import everything into this...can you 
> compact that one?
> 
> It sounds like you have a improper shutdown or free up..and the mdb files is 
> now damanged....
> 
> Also, what format of mdb file are you using...(the default is 2000...but 
> give the 2002-2003 format a try).
> 
> 
> -- 
> Albert D. Kallal   (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKal...@msn.com
> http://www.members.shaw.ca/AlbertKallal 
> 
> 
>