By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,584 Members | 3,447 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,584 IT Pros & Developers. It's quick & easy.

Compact and Repair Database URGENT.... Help me please...

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <pr*****@netspace.net.au> wrote in message
news:cr**********@otis.netspace.net.au...
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

Nov 13 '05 #2

P: n/a
It worked

Thank you so much.... much apreciate it

Paolo

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in
message news:CWJDd.1159$F97.510@trnddc06...
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" <pr*****@netspace.net.au> wrote in message
news:cr**********@otis.netspace.net.au...
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


Nov 13 '05 #3

P: n/a
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" <pr*****@netspace.net.au> wrote in message
news:cr**********@otis.netspace.net.au...
It worked

Thank you so much.... much apreciate it

Paolo

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in message news:CWJDd.1159$F97.510@trnddc06...
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" <pr*****@netspace.net.au> wrote in message
news:cr**********@otis.netspace.net.au...
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



Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.