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

Arvin Meyer [MVP]

View profile

More options Jan 23 2006, 3:12 pm

Newsgroups: microsoft.public.access

From: "Arvin Meyer [MVP]" <a...@m.com>

Date: Sun, 22 Jan 2006 23:12:22 -0500

Local: Mon, Jan 23 2006 3:12 pm

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
  

I'll suggest 3 things:

1. If this started to happen after an automatic update, roll back to the
machine state before the update.
2. Shut down McAfee (disconnect from the Internet before you do). Change
your AV if this works. I use AVG without any problems with Access.
3. Close all objects and code windows before attempting a compact.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"R J Kershaw" <RJKers...@discussions.microsoft.com> wrote in message
news:262C14E7-20C5-4CE6-8D47-D1EB192667C1@microsoft.com...

> It's a 3-month old single machine (Dell)
> The hardware is unaltered
> The operating system is original and updated only by MS automatic updates
> The application software (MS Office 2003 Pro) is as pre-installed.
> No network connection / single-user with full rights
> McAfee Security Center is running, with rights granted to MS Access
> Thanks for your response,
> R J Kershaw

> "Arvin Meyer [MVP]" wrote:

> > Does it happen on every machine? or just 1 machine? What other software
is
> > running? Does this machine have older hardware? Has the operating system
> > been upgraded? or is it the original system that was first loaded on the
> > machine? Is the machine on the network? What permissions do the users
have?

> > The answers to these questions may lead us to a solution.
> > --
> > Arvin Meyer, MCP, MVP
> > Microsoft Access
> > Free Access downloads
> > http://www.datastrat.com
> > http://www.mvps.org/access

> > "R J Kershaw" <R J Kers...@discussions.microsoft.com> wrote in message
> > news:B61B1879-42EA-4BDD-9514-DA1B2ED18A0D@microsoft.com...
> > > 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