Go to Google Groups Home    microsoft.public.access
Re: Why does system crash when Compact and Repair Database is used

R J Kershaw <rjkers...@discussions.microsoft.com>

Many thanks for your kind assistance.
Bob K

"Arvin Meyer [MVP]" wrote:
> 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?