table 'tempmsysaccessobjects' already exists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top