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?
Reply-To: "Albert D.Kallal" <PleaseNOOOsPAMmkal...@msn.com>
From: "Albert D.Kallal" <PleaseNOOOsPAMmkal...@msn.com>
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 16:30:55 -0700
Lines: 28
Organization: HCS Consulting Group
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Message-ID: <eOEJov6HGHA.240@TK2MSFTNGP11.phx.gbl>
Newsgroups: microsoft.public.access
NNTP-Posting-Host: s01060004e28ccb3d.ed.shawcable.net 68.150.2.213
Path: g2news1.google.com!news2.google.com!news4.google.com!newshub.sdsu.edu!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl

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