table 'tempmsysaccessobjects' already exists

C

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?
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top