This is really weird. I have a query in sql that runs like this:

SELECT * FROM uvTTExport option (force order)

It runs fine and returns 800+ records.
I need to run this query in Access so I can use some Visual Basic + MAPI
code to process the records... so I created a pass-through query with the
same syntax. It runs perfectly but returns no records! In both cases I am sa
and have dbo permissions on the database (both in SSQL query analyzer and
the ODBC I created for the pass-through).

I have spent hours on this can and can't work out what is going on.
Anyone got any ideas?

Al Blake, Australia

Is the "returns records" property of the query set to true?

-- Mary
MCW Technologies
http://www.mcwtech.com

On Tue, 30 Sep 2003 19:46:15 +1000, "Al Blake" <al@blakes.net> wrote:

>This is really weird. I have a query in sql that runs like this:
>
>SELECT * FROM uvTTExport option (force order)
>
>It runs fine and returns 800+ records.
>I need to run this query in Access so I can use some Visual Basic + MAPI
>code to process the records... so I created a pass-through query with the
>same syntax. It runs perfectly but returns no records! In both cases I am sa
>and have dbo permissions on the database (both in SSQL query analyzer and
>the ODBC I created for the pass-through).
>
>I have spent hours on this can and can't work out what is going on.
>Anyone got any ideas?
>
>Al Blake, Australia
>