|
| 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
March 25th 07, 08:36 PM
posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
|
|||
|
|||
Access pass-through query to SQL DB
";;;;;;]'" [';;;;;;;;;;;;;;;;;;;;;; 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! 
|
| Ads |
| 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 | February 8th 07 12:24 AM |
| Bcc messages from Access 03 to Outlook using query | Ultraviolet47 | Outlook and VBA | 7 | November 28th 06 11:15 PM |
| using access query to populate outlook distribution list | Iona | Outlook - General Queries | 0 | July 11th 06 07:39 AM |
| For MS MVP's to pass on | ADE AYORINDE | Outlook Express | 1 | January 17th 06 09:04 AM |
| Running query from Access Form commmand using VBA code | Berny | Outlook and VBA | 4 | January 16th 06 03:12 PM |
Linear Mode
