Append Query - destination table not available

[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

 

[Jeff Boyce]

Johanna

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

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
'====================================================

 

[Elfnut]

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

 

[Jeff Boyce]

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

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

 

[Elfnut]

Hi John,

That did the trick - thanks again for your help!
-Johanna