2 Gig Database won't compact....

[Phil Davy]

It keeps saying "Table TempMSysAccessObjects already exists"

Any chance of some help with this please?

 

[SEAN DI''''ANNO]

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]

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

Many thanks - will give that a go!

 

[Tony Toews]

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

 

[Tony Toews]

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]

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!

 

[Douglas J Steele]

Consider using a temporary database for your temporary tables.

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

 

[Tony Toews]

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