Linked Table - Query Table List Missing Fields?

Hi, I have a Access 2003 mdb that I have used for years that has worked
OK. Recently one of my queries malfunctioned to an external Progress
db's linked table. Specifically, the query's table list is missing many
of the fields in the table though when I inspect the linked table in the
Tables Objects Section I see all the fields. How can I fix my query?

TIA,
Dan

Why post the same question in different newsgroups? (already answered in the
other newsgroups you posted in).

If your situation is one of the (few) unusual circumstances in which it is
necessary/appropriate to post in more than one 'group, please post once,
'naming' all the 'groups in the To/Newsgroups line.

That way, an answer in one newsgroup shows up in the other ... and the folks
who volunteer their time here are stepping on each onther's answers...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"LightBulb" wrote in message
...
Hi, I have a Access 2003 mdb that I have used for years that has worked
OK. Recently one of my queries malfunctioned to an external Progress db's
linked table. Specifically, the query's table list is missing many of the
fields in the table though when I inspect the linked table in the Tables
Objects Section I see all the fields. How can I fix my query?

TIA,
Dan

First make a backup of the database file and put it away somewhere safe.

Next do a compact and repair. See if that fixes things.

If not, drop the linked table and try to re-link it using the Linked Table
Manager.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"LightBulb" wrote:

Hi, I have a Access 2003 mdb that I have used for years that has worked
OK. Recently one of my queries malfunctioned to an external Progress
db's linked table. Specifically, the query's table list is missing many
of the fields in the table though when I inspect the linked table in the
Tables Objects Section I see all the fields. How can I fix my query?

TIA,
Dan
.