Results 1 to 3 of 3
  1. #1
    fishhead is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    167

    How is data pulled out of back end?

    Can someone explain to me how the data arrives at my front end workstation when i'm querying data from a back end table?



    I have a backend table with +20k records in it and when my frontend query is asking for one specific record it lags over the network before displaying the data.

    The frontend query is only asking for 1 record with 3 fields of data . The backend table has approx 50 fields of data per record.

    It seems like the front end query is pulling all the fields for all the 20k records onto the frontend dbase and then the front end query is sorting through this data to display the 3 fields of data for the 1 specific record i'm asking for? Is this how the queries work?

    If so how would i tell the front end to only pull the 1 record through the network from the backend to the front end (without having all this unnecessary traffic over the network - which is causing the slow speed?

    Thanks in advance

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    thats what keys are for,
    select * from table where [id]=123

  3. #3
    fishhead is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    167
    WOW what a difference! thanks much!!!

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

Similar Threads

  1. Not all data being pulled with queries
    By joedean6 in forum Access
    Replies: 4
    Last Post: 11-23-2015, 10:43 AM
  2. data pulled from sub form not working
    By dm117 in forum Access
    Replies: 1
    Last Post: 08-13-2013, 12:11 AM
  3. Replies: 1
    Last Post: 06-28-2013, 12:54 PM
  4. Replies: 4
    Last Post: 05-21-2012, 08:21 AM
  5. Pulled Data Not Saving
    By Rookie in forum Access
    Replies: 4
    Last Post: 08-05-2011, 05:12 AM

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