Access Frontend and SQL Backend Database Question

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Lynx101
    #1

    Access Frontend and SQL Backend Database Question

    Background:
    I have recently started to look at converting an access backend into
    an SQL backend.

    Question:
    By default, when using a query in access does the SQL server only send
    the records requested from the query OR does SQL still send everything
    and the filtering is done by Access?

    If the latter, how to I get SQL to do the hard work and not access?

    Thanks
    Matt

    Tags: None
    • Rick Brandt
      #2
      Re: Access Frontend and SQL Backend Database Question

      Lynx101 wrote:
      Background:
      I have recently started to look at converting an access backend into
      an SQL backend.
      >
      Question:
      By default, when using a query in access does the SQL server only send
      the records requested from the query OR does SQL still send everything
      and the filtering is done by Access?
      "Still"? That suggests you think Access/Jet sends everything. Access/Jet does
      not and neither will a SQL Server back end.
      If the latter, how to I get SQL to do the hard work and not access?
      A standard Access query against an ODBC linked table will usually send most of
      the request to the server, but the amount of work done on the server varies
      depending on the structure of the query. To guarantee 100% work by the server
      you use a passthrough query. Only problem is that passthrough queries are
      always read-only.

      --
      Rick Brandt, Microsoft Access MVP
      Email (as appropriate) to...
      RBrandt at Hunter dot com


        Comment

        • Albert D. Kallal
          #3
          Re: Access Frontend and SQL Backend Database Question

          Question:
          By default, when using a query in access does the SQL server only send
          the records requested from the query OR does SQL still send everything
          and the filtering is done by Access?
          yes, by default, only the one record is transmitted. So often, a form is
          loaded directly against a large table without filters.

          In the case of a jet back end on a network, or sql server, if you restrict
          the record to be loaded, then ONLY that record is transferred. This applies
          to sql server, or a *even* standard back end file share mdb file.


          --
          Albert D. Kallal (Access MVP)
          Edmonton, Alberta Canada
          pleaseNOOSpamKa llal@msn.com


            Comment

            Previous template Next
            Working...