2 Gig Database won't compact....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Damn good idea - that would sort the problem with corrupt objects.

Many thanks - will give that a go!
 
SEAN DI''''ANNO said:
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.
Click to expand...

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 said:
It keeps saying "Table TempMSysAccessObjects already exists"
Click to expand...

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!
 
Phil Davy said:
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.
Click to expand...

Doug has given you the answer with the temp tables MDB.
Long live SQL server!
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compact and Repair Problem 6
Database compaction 2
XP A2K TempMSysAccessObjects Runtime No Permission 1
compact and repair, Table "TempMSysAccessObjects" already exists 1
Error "Table 'TempMSysAccessObjects' already Exists." 1
Fw: Compact and Repair Database URGENT.... Help me please... 1
Compact & repair 1
delete a temparory object - compact error 1

Back
Top