Append Query

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

John Spencer

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
 

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 Problem 1
Problem With Autonumber & Append Query 2
Test If a macro/query has already been run 1
Append only Null records in table 2
Can't create append query 2
Not able to use append query 4
Brackets in the Append To row of an Append Query 2
Query combobox unbound column 1

Top