Access 2002

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

I just recently started to get an error 3010 on closing my
DataBase. It states that [Table 'TempMSysAccessObjects'
already exists]. In the help notes it indicates that I
tried to save or rename a table that already existed. I do
not remember doing that since I have been using this Data
Base for a while now without modifications. It does not
seem to affect the use or functionality of the DB, but I
would like to find out what I may have done and how I can
fix it so the message goes away.
 
I just recently started to get an error 3010 on closing my
DataBase. It states that [Table 'TempMSysAccessObjects'
already exists]. In the help notes it indicates that I
tried to save or rename a table that already existed. I do
not remember doing that since I have been using this Data
Base for a while now without modifications. It does not
seem to affect the use or functionality of the DB, but I
would like to find out what I may have done and how I can
fix it so the message goes away.
Click to expand...

A couple of suggestions:

MAKE A BACKUP FIRST! This database may be corrupt; don't overwrite any
existing backups, you may need them if these ideas damage the database
further.

- Open Tools... Options and check the Show System Objects checkbox.
Then open the Tables window and delete TempMSysAccessObjects; then
rehide the tables. See if this resolves the problem.

- If that doesn't work - or instead, if you want to skip the first
suggestion - create a new empty database and use File... Get External
Data... Import to import everything, thereby giving you a clean set of
systems tables.
 
Back
Top