|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
August 20th 07, 06:23 AM
posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
|
|||
|
|||
Access pass-through query to SQL DB
";;;;;;]'" [';;;;;;;;;;;;;;;;;;;;;; wrote in message news:... ";;;;;;]'" [';;;;;;;;;;;;;;;;;;;;;; wrote in message news:... ";;;;;;]'" [';;;;;;;;;;;;;;;;;;;;;; wrote in message news:... '[[;;;;; ]''''''''''''''''''''''''' 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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Access pass-through query to SQL DB | ]' | Outlook Express | 0 | July 29th 07 10:42 PM |
| Access pass-through query to SQL DB | ]' | Outlook Express | 0 | July 29th 07 08:56 PM |
| Access pass-through query to SQL DB | ]' | Outlook Express | 0 | March 25th 07 08:36 PM |
| Access pass-through query to SQL DB | ]' | Outlook Express | 0 | February 8th 07 12:24 AM |
Hybrid Mode
