Results 1 to 4 of 4

Thread: Table Missing

  1. #1
    Join Date
    Jan 2006
    Posts
    54

    Unanswered: Table Missing

    I have just tried to create an Append Query in a regulary used DB.

    When I select append and then try and select the table, it is missing from the drop down list.
    The table is the first table in the DB (Alphabetically), when I add another table above it the table then appears for me to select?

    I've checked other DB's and it seems to be doing it in that aswell?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I've never encountered this problem personally... but I have heard about this problem before. Can you upload a file that exhibits this behaviour so that I can take a look at it?

    I can only guess at things like Compact and Repair and creating a new database and importing your objects into it... that kind of thing.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jan 2006
    Posts
    54
    I did some more searching after I posted and seem to have found the cause.
    It appears to be a combination of SP3 and the Primary Key.

    I tested a DB on an another machine with an older version of Access and the table was available.

    The table I was trying to select did not have a Primary key defined.

    As soon as I defined a Primary Key, the table appeared in the drop down list.

    A Microsoft Bug perhaps

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sounds like it.

    But it's good for every table to have a primary key Perhaps this is why I have never encountered this problem since I religiously create a primary key as the first act of creating a table.

    Thanks for the details
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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