Linked Table - Query Table List Missing Fields?

L

LightBulb

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
 
J

Jeff Boyce

Dan

Any chance someone's changed the definition of that external (linked) table?

Regardless, could you just re-build the query, pointing (again) at the
linked table?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lined Table - Query Table List Missing Fields? 1
New records in FE linked table not showing up in BE table. 1
converting linked csv files to tables 5
Auto refresh linked excel table from access database 1
Updating Data in a Linked Table Not Supported 2
Sql Server linked table and NULL bit fields 2
linked table queries 0
Linked Table Manager works one at a time 4

Top