QUERY Using ODBC fails

[RiderJon]

I have a database polling info from an ODBC connect. The ODBC tables open fine when I double-click on it.

However, when I try to run a qry from it, it fails. This same query was working fine for a long time. By the way, this query is set-up by linking 4 ODBC tables.

Any suggestions? Thank you,



RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave

 

[RiderJon]

In addition,

The links in the query work fine. For instance, I added one table at a time and check it. It works until the moment all 5 are connected together.

No matter which table of the 5 I add last, the completed query fails.

RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave