Problems with Access SQl pass-through query.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass Through Query - not returning rows 1
Pass-Through Query Error 1
Pass Through Query .sql query 3
Question on Pass-through Query 4
Access Pass-through Query to SQL Server 7
Using pass-through query results in forms 0
Update pass through query of report recordsource 2
SQL pass thru query from code always propting for DSN 5

Top