A
Al Blake
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
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