By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,076 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Access APD question.

P: n/a
ken
Hi,
If you sent a view from SQL server 2005 to Access, and access did
something like SELECT * FROM vwNAME WHERE FieldName = SomeFilter. Would
you SQL server transfer the whole view or would it transfer just the
records that access needs?

Thanks

Aug 17 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Baz

"ken" <gg****@gmail.comwrote in message
news:11**********************@74g2000cwt.googlegro ups.com...
Hi,
If you sent a view from SQL server 2005 to Access, and access did
something like SELECT * FROM vwNAME WHERE FieldName = SomeFilter. Would
you SQL server transfer the whole view or would it transfer just the
records that access needs?

Thanks
I assume you mean ADP not APD.

In an ADP, there is no Jet query engine at the client, all SQL is executed
by SQL Server i.e. only the results get returned to the Access client.
Aug 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.