Error message when trying to Compact Database

[Dylan]

Hi I am wondering if the resident guru's can please help me with another problem?

I have started to get the following popup message when trying to compact the database automatically on close or at any other time I try to do a Compact of my database.

'Table "TempMSysAccessObjects" Already Exists'

I have searched for this table in the database and have also made sure that no duplicate table names exist in the database.

I assume that ACCESS makes a copy of the database somewhere before it begins to compact same.

Has anyone seen this message before and do you know how I can fix same?

 

[Dylan]

Just a quick update. I am using ACCESS 2002 on Windows XP

I found using search a recommendation from GHudson to download JETCOM.EXE from the microsoft site. I did this and was able to compact the database successfully. I then opened the newly compacted database and found that it works ok. But as soon as I go to close same I get the original error i.e.

 

[Pat Hartman]

Sounds like corruption. I would recreate the db. Open a new db and import all your objects.

 

[Dylan]

G'day Pat,

I did as you suggested. It worked a treat.

Many thanks again for your prompt help and suggestion.

What a bonza site to have folks such as yourself and others providing guideance and coaching.

Cheers from Down Under,

Dylan.