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@netspace.net.au> wrote in message
news:crnrdg$5m5$1@otis.netspace.net.au...[color=blue]
> It worked
>
> Thank you so much.... much apreciate it
>
> Paolo
>
> "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SP AM> wrote[/color]
in[color=blue]
> message news:CWJDd.1159$F97.510@trnddc06...[color=green]
> > 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...[/color][/color]
to[color=blue][color=green]
> > 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[/color][/color]
Database[color=blue][color=green]
> > 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[/color][/color]
built-in[color=blue][color=green]
> > system tables (all table names starting with "MSys..."). Then, open a
> > module in the VB Editor and compile all code. Close the new database[/color][/color]
and[color=blue][color=green]
> > 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@netspace.net.au> wrote in message
> > news:crnpec$4ud$1@otis.netspace.net.au...[color=darkred]
> >> Hi,
> >>
> >> I am trying to compact and repair my database, however every time I try
> >> it
> >> comes up a message saying: Table: "TempMSysAccessObject already[/color][/color][/color]
exists",[color=blue][color=green][color=darkred]
> >> 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
> >>
> >>[/color]
> >
> >[/color]
>
>[/color]
