What does the message “Table TempMSysAccessObjects already exists” mean?
This message occurs when you try to close your database with ‘compact on close’ or when you use the menu Tools–>Database Utilities to compact the database. When you make changes to data, objects or code in an Access database, new space is allocated for the new information. Deleted or old information is merely made ‘unavailable’, but it still occupies space. Thus, your database can grow very large during development but contain a lot of wasted space. During live use, changes and additions to data can slow down the database as access times increase. By compacting the database, you release the wasted space and tidy up (reorganise) the database. Access compacts your database by creating a new version, copying across the current information and ignoring the old stuff, then deletes the old version and gives the new (compacted) version the name of your original database. But it needs space available on your disk to be able to do this. Access Help has some useful information; use the Answer W
