I am creating an append query in Access 2003. I began by creating the table
that the append query will drop the data into. However, when I select the
append query option and click the Table Name drop down, the table that I
created and saved does not appear. Any thoughts on why that might be? This
is happening to me on 2 computers both running WinXP and Office 2003.

Thanks!!!

Is it the first one alphabetically? If so create another table that will be
the first alphabetically. That's a bug, forget where I saw the description
of the bug (check allen brownes site would be my guess).

If taht doesn't work my next guess is something along the lines of
refreshing the table collection.

HTH,
Mark
RPT Software
http://www.rptsoftware.com

"DS" <(E-Mail Removed)> wrote in message
news:E12B7A20-E6D8-4418-B8F4-(E-Mail Removed)...
>I am creating an append query in Access 2003. I began by creating the
>table
> that the append query will drop the data into. However, when I select the
> append query option and click the Table Name drop down, the table that I
> created and saved does not appear. Any thoughts on why that might be?
> This
> is happening to me on 2 computers both running WinXP and Office 2003.
>
> Thanks!!!