Compact & Repair

[kjcmas]

Okay... unlike my last post (although unintentional), this is legitimate.

Whenever I do a compact and repair on my database, access crashes and offers to attempt to repair my db. IF I allow it to do that, it will blow away all of my VBA code and so everything stops working.

If i uncheck the repair box, access will just close. I can reopen my db myself and it's find. I'm not sure about any repairs (never understood, what it's repairing), but it's definately compacted any everything is fine.

So why does it crash and why does it eat my db unless i uncheck the box upon crashing?

 

[boblarson]

Try to compile it (go to the VBA window and select DEBUG > COMPILE) so you can see if there's any "rogue" code out there that might be causing this.