Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
microsoft.public.access
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
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
 
R J Kershaw  
View profile  
 More options Jan 23 2006, 6:10 am
Newsgroups: microsoft.public.access
From: "R J Kershaw" <RJKers...@discussions.microsoft.com>
Date: Sun, 22 Jan 2006 11:10:03 -0800
Local: Mon, Jan 23 2006 6:10 am
Subject: RE: Why does system crash when Compact and Repair Database is used
Reply to author | Forward | Print | View thread | Show original | Report this message | Find messages by this author
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?


    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.
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google