Results 1 to 2 of 2
  1. #1
    DougW659 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    1

    Can access utilize SQL Server resources to query data in linked tables

    Hi, I am wondering if anyone knows whether or not Access can utilize the CPU/RAM resources of a SQL Server database when querying data in that database through linked tables? Or is the Access query always done 'locally' using the resources of the machine actually running Access?



    My department was recently given access to a SQL Server database using Access as the 'client', and our performance of querying the database has been pretty bad.

    Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Did you post this earlier? I think maybe 2 moderators each deleted one of your two duplicate threads at the same time (I was one of them). Sorry about that.

    In any case, Access (JET/ACE) is pretty good about sending SQL back to the server to process when it can. If syntax or a function is used that the back end doesn't know, it will have to send everything to the front to process, which will typically result in bad performance. There's a lot of good info here, including a discussion of this point:

    Beginning Sql Server Development - UtterAccess Discussion Forums
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 05-21-2012, 07:00 PM
  2. Replies: 3
    Last Post: 05-17-2012, 05:41 AM
  3. Replies: 3
    Last Post: 01-03-2012, 12:28 PM
  4. Linked tables SQL Server login popup
    By geremore in forum Programming
    Replies: 3
    Last Post: 08-16-2011, 12:47 PM
  5. Replies: 2
    Last Post: 03-21-2011, 12:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums