Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243

    Unanswered: Table 'TempMSysAcessObjects' already exists

    Becaus my db is increasing, I wanted to compact and repair it, but it only gives me this error :

    Table 'TempMSysAcessObjects' already exists

    Anyone any idea?

    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198

    Re: Table 'TempMSysAcessObjects' already exists

    Are you trying to compact it into itself? Is it over 500MB? Are you doing the compact over the network?

    Access has a 1GB limit and can drop packets easily over a network. Your best bet is to copy the DB local to your machine, compact from one into the other then copy that one back out.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

  3. #3
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243

    Re: Table 'TempMSysAcessObjects' already exists

    Originally posted by jimpen
    Are you trying to compact it into itself? Is it over 500MB? Are you doing the compact over the network?

    Access has a 1GB limit and can drop packets easily over a network. Your best bet is to copy the DB local to your machine, compact from one into the other then copy that one back out.
    I copied all on my local hard disk, but it gives the same error.
    My mainDB only contains forms, queries and modules.
    I get my data from 3 other databases (2 on the server and 1 on the clients hard disk)
    Maybe it has something to do with that ?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    I just saw this topic in the MS knowledge base ... Try searching for it there ... www.microsoft.com

  5. #5
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243
    Originally posted by M Owen
    I just saw this topic in the MS knowledge base ... Try searching for it there ... www.microsoft.com
    I feel stupid.

    Everytime I got a problem I'm used to go to this forum.
    So I didn't even think of searching the web.
    However I did it this time and the problem is solved : my current DB is only 30% in size of what it was before.

    Thanks for the hint.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •