TempSysAccessObject already exists

[Alan]

Have installed a Access 2002 db FE/BE db onto a new WinXPPro pc acting as
server. The previous server was running same version of Access under
Win98SE.

What is being found is that the above message pops up whenver someone trys
to access the db over the network. This error message did not occur under
Win98SE.

What does this message refer to and how to overcome it.

Any advice and suggestions please

Alan

 

['69 Camaro]

Hi, Alan.

First, make a backup copy of the database, just in case something goes
wrong. Now, open the database and select the Tools menu -> Options... to
open the Options dialog window. Select the "View" tab, then check the
"System objects" check box. Select the "OK" button to save your change.

In the Database Window, select the "Tables" tab. Scroll down to the
"TempMSysAccessObjects" table and delete it.

Select the Tools menu -> Options... to open the Options dialog window.
Select the "View" tab, then uncheck the "System objects" check box. Select
the "OK" button to save your change.

Select the Tools menu -> Database Utilities -> Compact and Repair Database
to compact the database. When it is finished compacting, close the
database.

Attempt to access the database from across the network as before to
determine whether the problem has been fixed. If not, create a new database
file and import all of the objects from the original database, except the
built-in system tables (all table names starting with "MSys..."). Then,
open a module in the VB Editor and compile all code. Close the new database
and attempt to access the database from across the network as before.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Alan]

Hi Gunny

Thank you - that that sorted the problem.

What is likely to have caused the problem and is likely that any damage to
the BE db would have has occured?

Alan

 

['69 Camaro]

Hi, Alan.

You're welcome!

What is likely to have caused the problem

The "TempMSysAccessObjects" table is a system table that Jet uses while
doing its housekeeping. For some reason while Jet was processing the
database, the processing was interrupted or incomplete. This table was not
deleted, but it should have been. Because this table already exists when
Jet starts to do further housekeeping, when Jet attempts to create a brand
new table with this same name, it fails. Hence, the error message.

is likely that any damage to
the BE db would have has occured?

It's possible that corruption has occurred, but if it's a simple corruption,
then a compact and repair will fix it. If it's a more complex corruption,
then you'll likely find out fairly soon, because the database application
either won't open or it will act in a bizarre, unexplainable manner. If
that happens, you'll have to restore the database file from a backup.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)