View Single Post
  #1  
Old August 20th 07, 05:23 AM posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
]'
external usenet poster
 
Posts: 7
Default Access pass-through query to SQL DB

;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!





Ads
 

Ringtones - Bad Credit Mortgages - Compare - Loans - Mortgage Calculator