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: AcYffxBxRVonYlpRTyakNfyBfOuehw==
X-WBNR-Posting-Host: 64.108.174.86
From: "=?Utf-8?B?VGF0YWthdQ==?=" <Tata...@discussions.microsoft.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 10:10:02 -0800
Lines: 26
Message-ID: <3B0315A8-90D9-496E-A473-1B4CFE688724@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!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshub.sdsu.edu!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
I sometimes come across the problem where compacting and repairing a database
will actually corrupt my database, or invalidate the links to my tables.
Mostly I think this is due to the complexity of the front-end I am working
on, or the number of different databases I'm linked to, or just whatever else.
Anyway, make sure you're making a backup copy of your database before you
try to compact and repair. You said yours is crashing when you try doing
that, so test it on a simple database to see if it'll work on something
small. If that doesn't work, try converting to an older version of Access
first (Acces 2000 or in an extreme circumstance, Access 97). Failing that,
try compacting on a different machine. If it's still crashing, then it's
probably an Access problem, and you'll want to re-install Office on your
machine. If it's not working by that point, I would personally re-install
the OS (because it might be a library or extension problem), but that's just
me. I'm odd like that. :-p
hth,
Nick
"R J Kershaw" 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?
|
