Windows logoIt seems that only rare and obscure software glitches come my way.

Attempting to Compact and Repair a Microsoft Access 2002 database I received an error that “TempMSysAccess objects” already exists. In true Microsoft form there was no further explanation if the Compact/Repair operation had aborted-due-to-error or completed-with-warnings.

The error refers to an internal table used by Access and is hidden by default. Enable it via Tools / Options / View and “Show Hidden objects” and “Show System objects.” Delete the table and you’re good to go.

Solution found here.

Related posts: