Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compact and Repair Error causing Temptable?

Status
Not open for further replies.

kvest

Technical User
Jan 10, 2005
62
US
I attempted to compact and repair a database (Access 2000) and got an error due to insufficent room on my USB flash drive. I then moved it to my harddrive and attempted it again. I now get an error box that states "Table TempMsysAccessObjects already exists" with the choice of OK or Help. If I select Ok, the database opens, but cannot be compacted or repaired.

I cannot locate any table named that name...HELP!!!
 
I found it after activating hiden and system file viewing. I was able to rename it and then save and exit. Then reopen and compact and repair....I paniced for a few.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top