Append Query

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a table which I would like to append a query to. When I click on
append query and the drop down menu for the table's option, the table that I
want to append to doesn't show up. Can anyone offer any suggestions?

Thanks in advance!
 
This is a bug in Access 2003 SP3. As a guess the table you want to append to
is the first table in alpha order.

Quick and Dirty fix is to add a table to your database with the name AAAAA.
That should get you up and running.

I believe that there is a hotfix for this problem on Microsoft's site.



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top