microsoft.public.access | Google Groups

Re: Why does system crash when Compact and Repair Database is used

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

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?