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
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Append query for MS Access 2003 table linked to a Sharepoint listwith lookup fields 0
Some mail merge fields not pulling into document 2
Auto refresh linked excel table from access database 3
Text Field Filter vs. Number Field Filter on same table 0
Linked Table manager trashes CORRUPTS DATABASE 0
New records in FE linked table not showing up in BE table. 1

Top