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
>