Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Question Unanswered: Help with error message

    While doing a Compact and Repair, I get the following warning/error:

    TABLE TempMsysAccessObjects already exists.

    How do I take care of this?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    restart your computer.

  3. #3
    Join Date
    Nov 2003
    Posts
    300
    Originally posted by Teddy
    restart your computer.

    Okay, but where is this table that it says already exists? I can't find it anywhere..

  4. #4
    Join Date
    Feb 2003
    Location
    Winston-Salem,NC
    Posts
    34

    ....

    Actually your database maybe corrupt, according to the below website if you receive the error you said you did then it is corrupt. The error is down the page a little ways.

    http://www.e-tech.ca/001-AccessFAQ.asp

  5. #5
    Join Date
    Jan 2004
    Posts
    24
    Originally posted by databasemon
    Okay, but where is this table that it says already exists? I can't find it anywhere..
    By default, system objects (such as that table) are hidden. You have to go place a check mark in Tools->Options->View->Show System Objects to see them.

    And it is very likeley that your database has been corrupted.

    You will probably be able to get around the corruption by creating a new database, then doing a mass import of everything from the old database.

    I've fixed corrupted databases this way in the past.

Posting Permissions

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