Hi,

I am trying to compact and repair my database, however every time I try it
comes up a message saying: Table: "TempMSysAccessObject already exists",
whenever I try to look for this table I cannot find it anywhere... Any
clues...

Already went into the help file and nothing...
Also try to copy my database and the same message comes up

Thank you

Hi, Paolo.

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.

Open the database again and attempt to compact and repair again 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 compact and repair the database.

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.)


"Paolo" <prabbit (AT) netspace (DOT) net.au> wrote

It worked

Thank you so much.... much apreciate it

Paolo

"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro (AT) Spameater (DOT) orgZERO_SPAM> wrote in
message news:CWJDd.1159$F97.510 (AT) trnddc06 (DOT) ..

You're welcome!

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.)


"Paolo" <prabbit (AT) netspace (DOT) net.au> wrote