error message

[Liz]

Just recently I have been getting an error message when I
close the database. The message is
Table'TempMSysAccessObjects' already exists. Have looked
at help, but it seems I have two tables with the same
name. Checked all tables and no two have the same name
Please help if you can, Thanks

 

[John Vinson]

Just recently I have been getting an error message when I
close the database. The message is
Table'TempMSysAccessObjects' already exists. Have looked
at help, but it seems I have two tables with the same
name. Checked all tables and no two have the same name
Please help if you can, Thanks

TempMSysAccessObjects is a concealed systems table - try opening the
database, selecting Tools... Options, and checking the System and
Hidden checkboxes.

That said - you've probably got systems table corruption. I'd suggest
creating a new, empty database and using File... Get External Data...
Import to import all your objects, to get some clean systems tables.
Compact and Repair after you do the import.