Front/Back End

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi,
i am using Front and Backend Access 2000
I am just wondering when i write code in VBA/Query, 1.
the data at the backend send all the data to the client
then do the filter OR 2. the backend only send all the
requried (filtered) data to the client?
Of course, i know the method #2 is much better.
Thanks for the answer
 
The back end never sends anything at all. It is just a file sitting there.

Only where the code is being run (on your computer...with the front end) is
where things happen.

So, data is PULLED from the back end (the back end does not do anything, nor
does the back end "send" data!).

If your query can use a index, then only the data that matches the index
will be dragged across the network. So, if the query returns only 1 record,
then only one record will be pulled down the wire. If the query cannot use a
index (or no index is present), then all records in the table will be pulled
across the network even if the query eventually only returns one record.

So, you don't really have a choice here. You can run the query. However,
there is no ability to pre-filter the query on the back end, since the back
end does nothing anyway. All the queries are run in the front end. Even if
you place a query in the back end, the query is dragged across the network,
and then executed on the your front end computer anyway.

Of course, you realize that you don't have to install ms-access on the
computer where the back end is. (it is just a file share).
 
Back
Top