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: AcYfh3KdBMZFoU35RcOpN41/iIa7pA==
X-WBNR-Posting-Host: 195.93.21.3
From: "=?Utf-8?B?UiBKIEtlcnNoYXc=?=" <RJKers...@discussions.microsoft.com>
References: <B61B1879-42EA-4BDD-9514-DA1B2ED18A0D@microsoft.com> <3B0315A8-90D9-496E-A473-1B4CFE688724@microsoft.com>
Subject: RE: Why does system crash when Compact and Repair Database is used
Date: Sun, 22 Jan 2006 11:10:03 -0800
Lines: 38
Message-ID: <147918CA-D93C-42F9-9D66-A5B1B158E31B@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!border1.nntp.dca.giganews.com!nntp.giganews.com!newshub.sdsu.edu!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
Thanks for your reply.
I have already done the backup bit (sound advice anyway), but there is no
apparent corruption and the links are still there.
Will try the procedure with a completely unlinked DB.
Unfortunately there is no other machine to test this on so I hope it doesn't
come to the need for application or operating s/w reinstallation - I have too
much else going on!
Best regards,
Bob K
"Tatakau" wrote:
> 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?
|
