It keeps saying "Table TempMSysAccessObjects already exists"

Any chance of some help with this please?

Hi Phil,

Im not very technical at all but....why not set up a blank database
and import all objects from the 2gb database. This process would hopefully
identify any problems with corrupt tables etc.


"Phil Davy" wrote:

> It keeps saying "Table TempMSysAccessObjects already exists"
>
> Any chance of some help with this please?

Damn good idea - that would sort the problem with corrupt objects.

Many thanks - will give that a go!


"SEAN DI''''ANNO" wrote:

> Hi Phil,
>
> Im not very technical at all but....why not set up a blank database
> and import all objects from the 2gb database. This process would hopefully
> identify any problems with corrupt tables etc.
>
>
> "Phil Davy" wrote:
>
> > It keeps saying "Table TempMSysAccessObjects already exists"
> >
> > Any chance of some help with this please?

SEAN DI''''ANNO <(E-Mail Removed)> wrote:

>Im not very technical at all but....why not set up a blank database
>and import all objects from the 2gb database. This process would hopefully
>identify any problems with corrupt tables etc.

Yup, that'd be the first thing to try.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Phil Davy <(E-Mail Removed)> wrote:

>It keeps saying "Table TempMSysAccessObjects already exists"

Why is that MDB so large? That's very unusual.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Normally once compacted it is half a gig. It's just that we have to do a
load of make table queries every day and I think this creates a load of temp
tables. Hence the size keeps increasingup to the max of 2, then Access bombs
out.

Long live SQL server!


"Tony Toews" wrote:

> Phil Davy <(E-Mail Removed)> wrote:
>
> >It keeps saying "Table TempMSysAccessObjects already exists"
>
> Why is that MDB so large? That's very unusual.
>
> Tony
>
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
>

Consider using a temporary database for your temporary tables.

Tony's got a sample at http://www.granite.ab.ca/access/temptables.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Phil Davy" <(E-Mail Removed)> wrote in message
news:08DF7EDE-0527-47C9-B1ED-(E-Mail Removed)...
>
> Normally once compacted it is half a gig. It's just that we have to do a
> load of make table queries every day and I think this creates a load of
temp
> tables. Hence the size keeps increasingup to the max of 2, then Access
bombs
> out.
>
> Long live SQL server!
>
>
> "Tony Toews" wrote:
>
> > Phil Davy <(E-Mail Removed)> wrote:
> >
> > >It keeps saying "Table TempMSysAccessObjects already exists"
> >
> > Why is that MDB so large? That's very unusual.
> >
> > Tony
> >
> > --
> > Tony Toews, Microsoft Access MVP
> > Please respond only in the newsgroups so that others can
> > read the entire thread of messages.
> > Microsoft Access Links, Hints, Tips & Accounting Systems at
> > http://www.granite.ab.ca/accsmstr.htm
> >

Phil Davy <(E-Mail Removed)> wrote:

>Normally once compacted it is half a gig. It's just that we have to do a
>load of make table queries every day and I think this creates a load of temp
>tables. Hence the size keeps increasingup to the max of 2, then Access bombs
>out.

Doug has given you the answer with the temp tables MDB.

>Long live SQL server!

Yes, SQL Server certainly has it's place but I think we can get around
this problem quite easily.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm