table 'tempmsysaccessobjects' already exists

[crhp917]

whenever i close the access 03 database that i use, i get the error " table
'tempmsysaccessobjects' already exists ", and then the database closes. i an
unsure of the reason for this error, and hope there is an easy fix for this.
any ideas?

 

[Allen Browne]

This sounds like a corruption of the database, but fixable.

Go to:
Tools | Options | View
and check the boxes for Hidden and System objects.

On the Tables tab of the Database window, you should now be able to see
tempmsysaccessobjects. Try deleting it. If that works, compact the database.

If it doesn't work, create a new database and import all the other objects
(except this bad one) into the new database. For more detailed instructions,
follow the 6 steps for the first symptom here:
http://allenbrowne.com/ser-47.html#CannotOpenForm

 

[crhp917]

thank you, the problem was what you said. i did your fix, and it works fine.