MIG,
this can happen with A2003 with SP3 and hotfix - if the table you want is
the first one on your list of tables.
The work around is to create a new dummy table with a name like A1.
This new dummy table goes to the top of the list and when you want to append
to your other table you should be able to see it in the list.


Jeanette Cunningham -- Melbourne Victoria Australia


"MIG" wrote in message
...
I must be missing something really obvious, but I want to append some
rows to a table I've created, but when I change my query type to
Append, the list of tables I can choose to append to omits the table I
want, while showing the others.

The one I want to append to does appear if I try to show a table to
select from (but it has nothing in it yet).

What could prevent the table from being available to append to?

Thanks.