Access pass-through query to SQL DB
";;;;;;]'" [';;;;;;;;;;;;;;;;;;;;;; a écrit dans le message de news:
...
;H;IYHNUYJGH;BN';'GJGJ;UG
GG.HGJHTUUUUUUUU
UTTTTTTTTTUTTUUUUUUUUUUU
UTGGGGGGGGGGGGGG
";;;;;;]'" [';;;;;;;;;;;;;;;;;;;;;; wrote in message news:...
GGGGGGGGGGGGGGGGGUUUUUUUUUUUU
'[[;;;;;
]'''''''''''''''''''''''''
I want to build a pass-through query in MS Access 2003 to query a
back-end
SQL DB (2000). I can run the SQL query in MS SQL query analyzer
successfully
and return about 200 records (each row with about 15 fields).
However, when I run the same query in Access, I got a message
"Pass-through
query with ReturnsRecords property set to True did not return any
records".
The ODBC connection is configure via control panel/admin tool/ODBC, MS
SQL
server DSN configuration (under System DSN tab of ODBC Data Source
Administrator window)
any clue/hint is much appreciated!
|