Linked Tables and Views

[Paul Reed]

Hello,

When I link to a view in a SQL Server database. If I build
a report on that view, where is the query actually
executed? On the Sql Server box or is all the data dragged
down to the client and executed there.

Same question about a linked table. If I build a query in
access against a linked table, where is the query actually
executed?

I want to make sure that the result set that comes down to
Access on the client is just that...the result set...not
all the data that is then realized on the client.

Regards,

Paul

 

[Jeff Boyce]

Paul

If you've created a "view" in SQL-Server, SQL-Server does the heavy lifting.

If you create a query in Access, with both linked tables and views (?and
local tables), plus any local functions (i.e., Access does Date(),
SQL-Server does GetDate()), Access will have to decide how much to pull
down.

If you want to ensure that only the result set is pulled, you'll have to
ensure that there are no local-only functions, for one thing.

Good luck

(this is just part of the picture, but a place you can start looking...)

Jeff Boyce
<Access MVP>

 

[Guest]

many thanks Jeff.