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?

Albert D.Kallal

View profile

More options Jan 23 2006, 10:30 am

Newsgroups: microsoft.public.access

From: "Albert D.Kallal" <PleaseNOOOsPAMmkal...@msn.com>

Date: Sun, 22 Jan 2006 16:30:55 -0700

Local: Mon, Jan 23 2006 10:30 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
  

There has been a few posts that suggest that having code windows open can
case this..

Try he following:

exit the application

re-enter the application (hold down the shift key if you have any startup
forms..or any startup code that runs when the application loads).

now try a compact and repair. If this don't work..then I would suggest that
you create a new blank database..and import everything into this...can you
compact that one?

It sounds like you have a improper shutdown or free up..and the mdb files is
now damanged....

Also, what format of mdb file are you using...(the default is 2000...but
give the 2002-2003 format a try).

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKal...@msn.com
http://www.members.shaw.ca/AlbertKallal

Reply to author Forward