Access/SQL Sever - to link or not to link

[stanl]

stanl,

Have you tried running it as a pass-through query?

I think you missed the point of the post - it was more to indicate that perhaps VBA's cDate() is more optimized than Convert() - to a point - regardless as to whether the Access query is pass-through or not it is still faster - to a point.