Error message when exit .mdb file 1

[105]

I am getting the error message below when exit my .mdb file.
error message: Table 'TempMSysAccessObjects' already exists.

Anybody has idea what's causing the error ?

Thanks in advance !


... May

 

[madhouse]

Have you got a procedure in the On Close of any of your forms that refer to this table?

 

[105]

I have never created this table in my database.

 

[105]

Actual the only change I made to the database is to enable the automatically compact on close in Option menu. Could that cause any problem like this ?

 

[105]

I have disabled the compact on close option, it has no problem on exit.
Then I manually compact the database, I got the same error message again.
Looks like it has something to do with compact the database.

Has anybody experienced this before? Please help !!!

... May

 

[madhouse]

You may not have created the table by there must be a piece of code somewhere that is referring to it. Have you tried do a search within the Current Project (check the radio button Current Project) for that table?

 

[105]

I did the search but didn't find this table.

 

[throwdini]

This thread was helpful.

thread181-246434

I deleted the table and the error no longer shows up.

-Jay