Append Query - destination table not available

  • Thread starter Thread starter Elfnut
  • Start date Start date
E

Elfnut

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
 
Johanna

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

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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
'====================================================
 
Wow - for real? That is a trip! I don't know the SP - the DB is on my work
desktop. I'll try that next week as soon as I get back to the office.

Thanks!
Johanna
 
Thanks, John. I've never run across that before!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Well, I must admit I am going off my rather poor memory of reading about this.

I've never experienced this particular problem.

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