Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QUERY Using ODBC fails

Status
Not open for further replies.
RiderJon

RiderJon

Programmer
Aug 26, 2002
190
0
0
FR

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
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
86
gk53
gk53
betachristopher
  • Locked
  • Question
Use IF/ELSE in Query 1
Replies
3
Views
67
drlex
drlex
HoustonGuy
  • Locked
  • Question
CPU usage of a package using tables on another server
Replies
0
Views
37
HoustonGuy
HoustonGuy
PleaseWork
  • Locked
  • Question
Sql server query
Replies
1
Views
37
mrdenny
mrdenny
Lost500
  • Locked
  • Question
Upsizing access 2007 db to SQL 2005: ODBC connection failed
Replies
1
Views
35
bburnell
bburnell

Part and Inventory Search

Sponsor

Back
Top