|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: access, passthrough, query, sql |
| Thread Tools | Display Modes |
|
#1
August 20th 07, 05:23 AM
posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
|
|||
|
|||
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 |
|
#2
August 22nd 07, 05:18 PM
posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
|
|||
|
|||
|
Access pass-through query to SQL DB
Użytkownik ";;;;;;]'" [';;;;;;;;;;;;;;;;;;;;;; napisał w wiadomo¶ci ... ;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!
|
|
#3
|
|||
|
|||
|
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Access pass-through query to SQL DB | ]' | Outlook Express | 0 | July 29th 07 09:42 PM |
| Access pass-through query to SQL DB | ]' | Outlook Express | 0 | July 29th 07 07:56 PM |
| Access pass-through query to SQL DB | ]' | Outlook Express | 0 | March 25th 07 07:36 PM |
| Access pass-through query to SQL DB | ]' | Outlook Express | 0 | February 7th 07 11:24 PM |
| Bcc messages from Access 03 to Outlook using query | Ultraviolet47 | Outlook and VBA | 7 | November 28th 06 10:15 PM |
Linear Mode
