Join Expression Not Supported

V

Van T. Dinh

Sorry. Didn't see the last sentence.

It is certainly a lot more efficient if you use Pass-
Through Query or the SQL Server View. However, you will
need to test the SQL String of the Pass-Through Query /
View in the Query Analyzer.

It is unlikely the SQL String I posted will work as a Pass-
Through Query or View as CStr() is an Access VBA function
and probably not SQL Server function. You will probably
need to use SQL Server functions Cast() or Convert() in
Pass-Through Query or View.

HTH
Van T. Dinh
MVP (Access)
 

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

Query on SQL Server is fast, while Access is crawling 2
Question on Pass-through Query 4
Update pass through query of report recordsource 2
Dates are all the same 2
Access Pass-through Query to SQL Server 7
Date Format with Pass Through and form fields 2
Set Warnings false is misbehaving 3
SQL pass thru query from code always propting for DSN 5

Top