error during compacting a database

[Jacob Mathai]

when I compact a database, I get message : table 'TempMsysAccess objects' already exists.

OK help

I use access XP. I am the only one in the data base.
Any help will be appreciated.

 

[ghudson]

That is a systems table which means that your db is probably corrupted. I suggest that you import all of your db objects into a new db.

 

[Jacob Mathai]

thanks.
It worked.

 

[dug3241]

i just read your reply to how to solve this problem, but yet my database still works fine.
is there anyway in which i can stop the message appearing as it seems to have no determental affect on my database

Richard

 

[ghudson]

Your db is not ok if you are receiving that error. The fix is listed above. If you feel that your db is really ok than you do not need to do anything now. But later you will when the corruption affects your db so that their is data loss or it will not open at all. Life is a gamble. Take a chance.

 

[dug3241]

cheers, well as my system is for my A level coursework then aslo long as it lasts until firday when i have to demostarted it then i should be fine,
i have plently of backup copies so i 'should' be fine

cheers for a quick response

Richard

 

[Crilen007]

Why don't you just import the stuff into a new one?

It doesn't do anything but help.

 

[dug3241]

i know you can import tables and queries, but can you import forms and VBA coding

 

[Jacob Mathai]

When import forms and modules, the VBA comes along with it.
If you have specification files, you need to import them also.

 

[dug3241]

cheers, thanks, i have now imported my database, and it know works fine
cheers

 

[rglman]

Alternative solution...

1. Open Access,
2. Open your database,
3. Click "Tools",
4. Click "Options",
5. Go to the "View" tab,
6. Locate the "System objects" check box and select it,
7. Click "OK",
8. Go to the Database window,
9. Click "Tables" in the left-hand pane,
10. Locate the "TempMSysAccessObjects" table in right-hand pane,
11. Select and delete it.

Or, you can import all the db objects into a new db!