Where are queries executed?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Where are queries executed?
Back-end or Front-end?

I always heard that they are executed on the back-end of any database but in
Access they are stored in the front-end so, what is the right answer?

Thank you

Mauricio Silva
 
Mauricio Silva said:
Where are queries executed?
Back-end or Front-end?

I always heard that they are executed on the back-end of any database but in
Access they are stored in the front-end so, what is the right answer?
Click to expand...

The back end is just a file and there is not even a requirement that Access be
installed on the PC that houses the back end. Given that, the front end PC is
the only one running Access and therefore is the only that can possibly run the
query.
 
It depends on your set-up.

If you are talking about JET Back-End, the Queries are always executed in
the Front-End since JET Back-End is simply a file-sharing database.

If you are talking about other database engine Back-Ends, the normal SELECT
Queries are still handled by the Front-End except that Access/JET will pass
some criteria (those that Access/JET thinks that the Back-End
"understands"). If you want the Back-End to handle the Queries completely,
you need to use Pass-Through Queries. Note that in Pass-Through Queries,
you need to use the SQL syntax of the Back-End database engine rather than
the JET syntax.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top