Author Topic: Repair vs Compact of EAP file  (Read 3568 times)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8607
  • Karma: +257/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Repair vs Compact of EAP file
« on: August 13, 2015, 10:03:19 am »
In another post regarding problems with Office 2013 and EA v12, further testing makes us suspect a corrupted file that got propagated somehow.

We REGULARLY run the Integrity Checker ([Shift+F9]) to ensure the health of our EAP files.  We also run the Compactor frequently to keep our EAP file "tuned up".

However, this possible corruption has caused us to question whether the Compactor also does a Repair first.  I think in the "old days" (believe it or not, I was around when Access v1.0 was first available and used it) this was the case, but now I'm not sure.  Can anyone confirm if Compact also repairs or a separate Repair task is required?

TIA,
Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8085
  • Karma: +118/-20
    • View Profile
Re: Repair vs Compact of EAP file
« Reply #1 on: August 13, 2015, 11:44:40 am »
I don't know the full history, but I know that for JET 4, EA runs compact for both. JET 3.whatever there are separate commands but I have no idea if one automatically runs the other.

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8607
  • Karma: +257/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Repair vs Compact of EAP file
« Reply #2 on: August 13, 2015, 03:11:41 pm »
Quote
I don't know the full history, but I know that for JET 4, EA runs compact for both. JET 3.whatever there are separate commands but I have no idea if one automatically runs the other.
Thanks Simon,

I'm primarily interested in Jet 4, so just to make sure I correctly understand what you're saying:
Regardless of what MS Access might do, EA will run the compact for both the repair and compact menu items.

Consequently, if I want to ensure that I get a repair (in addition to the compact), I should choose the Repair option.

In the case of Jet 3.5, run each one separately, just in case...

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8085
  • Karma: +118/-20
    • View Profile
Re: Repair vs Compact of EAP file
« Reply #3 on: August 13, 2015, 04:30:14 pm »
For JET 4 run either command. They both do the same thing. For JET 3.5 run both, one may run the other inside JET, but I don't know.