Lined Table - Query Table List Missing Fields?

[LightBulb]

Hi, I have a 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 Ojects Section I see all the fields. How can I fix my query?

TIA,
Dan

 

[pietlinden]

Hi, I have a 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 Ojects Section I see all the fields.  How can I fix my query?

TIA,
Dan

Did you try deleting the link to the external table and re-creating
it? Then try rerunning your query.