Access 2000 compact and repair

  • Thread starter Thread starter HiDensity
  • Start date Start date
H

HiDensity

Hi, when I run compact/repair on db (about 5mb), the compact process halts
at about 25% complete. I can close the db, then re-open and continue to use
as normal. What types of things might prevent a successful compact process?
Thanks!
 
HiDensity said:
Hi, when I run compact/repair on db (about 5mb), the compact process halts
at about 25% complete. I can close the db, then re-open and continue to use
as normal. What types of things might prevent a successful compact process?
Click to expand...

Typically corruption. However how long have you let the compact halt?
I'd suggest giving it several minutes of non movement before
cancelling it. Also note that seeing non-responding in the task
manager window is misleading when doing long running operations such
as compacting.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top