Append Query Problem

D

DS

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!!!
 
M

Mark Andrews

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query 1
Can't create append query 2
Brackets in the Append To row of an Append Query 2
Not able to use append query 4
Problem With Autonumber & Append Query 2
Append Query Fails, MS Access 2000 bug? 5
Append Query 3
Append only Null records in table 2

Top