MS Access 2003 append query

wjeb
wjeb used Ask the Experts™
on
Why does the destination table I want to append to not appear in the drop down list when I try to create an append query to transfer data from one table to another?  The 2 tables have identical structures, 2 fields:  class and name.  No primary key in either table.  No restrictions set re duplicate entries in either field in either table.  Other tables and queries do appear.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Is it possible Hidden, ie is the Hidden property set to Yes?

mx
Commented:
I found an answer.  Apparently  there was a bug and the first table in the list does not appear in the drop-down list.  Creating a dummy table to be first in the list should solve the problem.

Author

Commented:
I found the answer from a search I did on Google.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial