Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Location
    Regina, Saskatchewan, Canada
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Append table query- missing table from drop down (Access 2003)

    Hi! I have done a search but could not find this problem.

    When I create an append to table query and try to select the table to append to (sorry for the lousy grammar!) it does not show up in the drop down list. In searching the internet, it appears I am not the only one with this problem so I thought I would find a solution on this site but either I cannot formulate the proper search words or it has not been discussed here. If someone can either direct be to the proper posts or has an answer to my problem, I would be most grateful.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Append table query- missing table from drop down (Access 2003)

    Download and install the Access 2003 hotfix package: April 16, 2008. One of the problems it fixes is "You install the Office 2003 Service Pack 3 on a client computer. Then, in Access 2003, the Append dialog box of an append query does not show all the tables within the database."

  3. #3
    New Lounger
    Join Date
    Jan 2004
    Location
    Regina, Saskatchewan, Canada
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Append table query- missing table from drop down (Access 2003)

    Thanks, Hans! I knew I could get the answer here.
    Bob

Posting Permissions

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