Append query

[AnnPhil]

Why would an existing table in my database not be seen in the list of tables to be appended when creating an append query?

I am trying to move some data from one table to another by using an append query but it will not let me select the table to be appended from the list of existing tables! It does not show up! What would cause this?

 

[DCrake]

Is the table selectable for other types of queries?
Have you tried typing in the SQL using the SQL view of the query?
Is it a linked table?
Is it an Access table?

 

[AnnPhil]

yes the table is selectable when performing a select query but not in an append query. I finally created a "make table" query and then was able to see that table when creating an append query, very strange!

It was just a simple 3 field access table and no it was not linked