Re: Append Query - destination table not available

There is a bug in Access 2003 SP3 that can cause this to happen - the first table alphabetically does not appear in the list.

One trick to fix it is to add a dummy table entitled AAAA. There is probably a fix for this on MS site.

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


Jeff Boyce wrote:
Johanna

Have you checked on the Tables tab to see if that table is listed?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Elfnut" <Elfnut@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:2F6DD8F4-7436-4AE4-9EE4-EFDAC61D8F9E@xxxxxxxxxxxxxxxx
Hello!
I'm using the Access 2003 Events template and am trying to append data to
one of the tables in the template - the Attendees table.

However, in selecting the Append query type, the Attendees table does not
appear as an option under "Append To/Table Name:" - all the other tables in
the database do appear.

The Attendees table does appear in the "Show Tables" list.

Any ideas?!

Thank you!
Johanna






.

Relevant Pages