Access hidden objects ??

[Mike Revis]

Hi group,
Access 2000 win xppro

I'm not sure if this is the correct group but here goes anyway.

I have a small application that I use in my business.

I have been using it without problems for about 3 years.

I have the full version of access developer xp on my box and I have the
runtime version running on two other boxes.

I have the app set to compact on close on all boxes.

Recently when I close the app on my box I get the following.....

Table TempMSysAccessObjects already exists.

This only appears on my box and not on the boxes with the runtime.

It doesn't appear to be having any adverse affect but I'm curious if anyone
can shed any light on why this might be happening.

As always, any thoughts, comments or suggestions are welcome.

Best regards

Mike

 

[ruralguy via AccessMonster.com]

On a backup of your db go to Tools>Options>View tab and check Show Hidden and
System objects. Then go look at your tables and delete the
TempMSysAccessObjects table. I think something may have happened while it
was compacting some time back. Give it a try for compacting. If that fixes
it then use it from now on. That happened to me one time and that's what I
did and have not had trouble since.