Filtering question

  • Thread starter Thread starter Savvoulidis Iordanis
  • Start date Start date
S

Savvoulidis Iordanis

How does access handle filtering on forms or reports? Which one of the
following is correct?

1) All data is returned to the form/report from the DB (locally or network)
and then the filter is applied
on the local app, which means that if a sql select gets 2000 records to the
app and the filter displays only 10
then all 2000 records travel to the app anyway

2) the filter setup on the form/report properties, is applied before the
records come over to the app.

Also, when we have a master and detail forms/reports, the linking fields act
as filters using the 1st or the 2nd method?

If developing net apps and the 1st is true, then I think all sql selects
have to have parameters. So now we get
to the next problem, of setting up a form with a recordsource that is a
saved query with a parameter. We get this ugly
parameter prompt when opening the form, without first filling the parameter

And life using Access XXXX goes on as difficult as it can...
What I need is a long holiday season...
 
Savvoulidis Iordanis said:
How does access handle filtering on forms or reports? Which one of the
following is correct?

1) All data is returned to the form/report from the DB (locally or network)
and then the filter is applied
on the local app, which means that if a sql select gets 2000 records to the
app and the filter displays only 10
then all 2000 records travel to the app anyway

2) the filter setup on the form/report properties, is applied before the
records come over to the app.
Click to expand...

Depends on whether there is an available index. If there is, the index is
pulled over the wire, Access uses that to identify the appropriate records,
and then only the data pages required to retrieve those records are pulled
over the wire.

If there is no index then your option (1) applies.
 
Back
Top