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 Crosstab Query to Existing Table 0
Adding data to MS Access from csv file 0
Append Query Problem 1
Test If a macro/query has already been run 1
Appending tables 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Problem With Autonumber & Append Query 2
Query combobox unbound column 1

Top