Questions on pass-thru queries

[vulcaned]

I'm thinking I might want to move the back-end to one of my Access97
applications to SQLServer instead of continuing to use Access jet but
before I start/do that I have several questions I'm hoping can be
answered as I have not yet used SQLServer for a back-end.

1. Just moving my tables from a jet back-end to a SQLServer back-end
and not changing anything else will not improve performance, True????

2. If I create pass-thru queries can they contain Access
functions(like: DatePart, CvDate, ABS, etc....) or do they need to be
pure SQL????

3. Can pass-thru queries be 'action' and 'select' queries????

4. Is there an Access add-in that will tell you which queries can
become pass-thru and which can't????

5. Is there an add-in or third party product that will convert a query
to a pass-thru query at an insertion point on a code page????

thanks
bobh.

[Steve Jorgensen]

On 4 Mar 2005 13:09:33 -0800, vu******@isp.com wrote:

I'm thinking I might want to move the back-end to one of my Access97
applications to SQLServer instead of continuing to use Access jet but
before I start/do that I have several questions I'm hoping can be
answered as I have not yet used SQLServer for a back-end.

1. Just moving my tables from a jet back-end to a SQLServer back-end
and not changing anything else will not improve performance, True????
Usually true. If the design already folllows good practices for C/S apps,
then you generally would see a speed improvement vs shared .mdb file on the
LAN.
2. If I create pass-thru queries can they contain Access
functions(like: DatePart, CvDate, ABS, etc....) or do they need to be
pure SQL????
They cannot contain Access or VBA functions, however, SQL Server has its own
functions that are similar.
3. Can pass-thru queries be 'action' and 'select' queries????
Yes.
4. Is there an Access add-in that will tell you which queries can
become pass-thru and which can't????
No. Short answer, though, most Access queries do not need to be converted.
Access generally does a decent job of forwarding query logic to the server for
you. A lack of pass-throughh queries is not the problem with most Access C/S
apps that are slow, it is that they retrieve large recordsets from the server
or use code loops where SQL set operations are more appropriate.
5. Is there an add-in or third party product that will convert a query
to a pass-thru query at an insertion point on a code page????

I'm not sure I understand your quesiton.

[vulcaned]

Hi Steve,
Thanks for your answer to my questions....
Q5 - I'm not sure what I meant :-)
I'll have to think onit somemore.
bobh.