Web Images Videos Maps News Groups Gmail more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Message from discussion Why does system crash when Compact and Repair Database is used?
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Tatakau  
View profile  
 More options Jan 23 2006, 5:10 am
Newsgroups: microsoft.public.access
From: "Tatakau" <Tata...@discussions.microsoft.com>
Date: Sun, 22 Jan 2006 10:10:02 -0800
Local: Mon, Jan 23 2006 5:10 am
Subject: RE: Why does system crash when Compact and Repair Database is used?
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?


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.

Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google