Error on compact and repair database

C

Chris B

I am trying to compact a database and keep geting an
error; TempMsysaccessobjects already excist! What do I do
to clear this up?

Thanks, Chris
 
G

Guest

Set "view sytsem objects" to TRU

If more than one table MsysAccessObjects exist, delete it

You need to have only these system tables (Access2k)
MSysAccessObject
MSysAccessXM
MSysACE
MSysObject
MSysQuerie
MSysRelationships
 

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

compacting problem 1
Compact and Repair Problem 6
Compact and Repair 2
tempmsysaccessobjects 1
Error 7846 Can't compact and repair current database 2
Error on Compact and Repair 4
Compact & repair 1
Database compaction 2

Top