I have a problem that just started, and not sure what is causing. Any input on problem determination or suggestions would be greatly appreciated (btw - first time poster here)
When I try to run compact and repair on any database that is ~500MB or larger, Access crashes . It is pretty consistent on when it crashes.. e.g. a DB that is 692MB crashes when the temp DB reaches 569MB.
Here is where it gets stranger. .problem happens on multiple databases and I can copy the DB to another computer with Access 2007 (Same version) and Compact/Repair works fine.
For problem / attempted corrections I have tried the following with no luck
- Checkdsk - OK
- Boot in Save Mode - Compact / Repair still crashes
- Move DB to another HD on my computer (Thinking I may have disk failing) - Compact / Repair still crashes
- Uninstall / Install Access - - Compact / Repair still crashes