Jun 26 2009

Resolve the TempMSysAccess error when compacting Microsoft Access databases

Published by Eric at 11:12 am under Windows

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:


Comments

blog comments powered by Disqus