Results 1 to 2 of 2

Thread: Access database query efficiency?

  1. May 25th, 2000, 10:04 PM #1
    Winla
    Winla is offline

    Thread Starter
    Addicted Member
    Join Date
    Jan 2000
    Location
    BC, Canada
    Posts
    142
    May I ask a fundamental question about Access database query?

    I know that when a Access database application make a query
    to another Access database through network, the whole
    table data are sent to client computer for processing,
    that is what desktop database means.

    But if I use SQL server as the database and Access data
    application makes a pass-through query, what is the dataflow for this case?

    Thx a lot

    [Edited by Winla on 05-26-2000 at 11:45 AM]
    Reply With Quote Reply With Quote
  2. May 26th, 2000, 02:26 AM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    The query is run on the server, using server resources, and the _results_ are sent to the client.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width