How reliable are pass-through queries?

  • Thread starter Thread starter Brett Rawcliffe
  • Start date Start date
B

Brett Rawcliffe

Hi,

As can be inferred from the subject line I would like
feedback on how reliable pass through queries are. I am
considering using them for a client server solution with
access as the client and SQL Server as the server. Any
comments on any limitations or problems that I may
encounter would be appreciated

Thanks

Brett
 
As your server, network, the SQL passed? If written properly, they work and
can provide performance improvements.
 
I don't have any problems with Past-Through Queries. In
fact, Pass-Through Queries are extremely fast if your SQL
is written properly (but this also applies to JET SQL).
You will need to know about the SQL syntax of MS-SQL
Server as there are differences between JET SQL and MS-SQL
Server SQL. In particular, you will need to know the MS-
SQL in-built functions.

Another thing you need to know is that JET is very
forgiving with type-casting. MS-SQL is very strict with
types and you have to watch out for type compatibility.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top