tempmsysaccessobjects

C

Chris B

When I try to compact my db I get an error that says my
table tempmsysaccessobjects already excists.

How do I fix this?

Chris
 
G

Guest

Chris B said:
When I try to compact my db I get an error that says my
table tempmsysaccessobjects already excists.

How do I fix this?

Chris
Click to expand...

I'd suggest creating a new, empty database and using File... Get External Data... Import to import everything from your database. It appears that a compaction didn't run to completion and your database may be corrupted!

If you have any objects with VBA code, type Ctrl-G to open the VBA editor, and select Debug... Compile <my database> immediately after the import to prevent the dreaded "Network Connection May Have Been Lost" bogus error.
 

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

Similar Threads

TempMSysAccessObjects 1
XP A2K TempMSysAccessObjects Runtime No Permission 1
Access 2002 & MSOffce XP 2
Compact and Repair 2
table 'tempmsysaccessobjects' already exists 2
Error "Table 'TempMSysAccessObjects' already Exists." 1
Database compaction 2
Compact and Repair Problem 6

Top