Results 1 to 4 of 4
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313

    In Access Form How Does Filter Work

    I have an Access Form whose Record Source is a large table on SQL Server. When I Load or Requery the form with a Filter for a particular record, does SQL Server return only the one record or does it return the whole table and Access (Jet) filters it to one record? If SQL Server returns the whole table, how can I change this so it sends only one record? Thanks, Eddie

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Isn't the form data source a table link?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313
    June7, in this case it is a SQL string that joins multiple tables (all linked to a backend database) and SELECTs a significant number of fields. Since we're about to try MS Azure (cloud based database) as the SQL Server, I want to try to limit the data traffic as much as possible. Right now, the backend is MS Access on a shared fileserver and when I open the form it takes 15 seconds to open, all the time showing "Running Query" in the status line.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Query with linked tables to me is same as setting RecordSource direct to linked table.

    You might find this discussion of interest https://www.accessforums.net/forms/slow-form-37479.html

    I'm really not knowledgeable enough to explain the inner workings of data connections.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 1
    Last Post: 08-16-2012, 01:51 PM
  2. Replies: 8
    Last Post: 07-27-2012, 12:23 PM
  3. Replies: 2
    Last Post: 11-12-2011, 08:37 AM
  4. Replies: 4
    Last Post: 07-14-2011, 09:49 AM
  5. Filter on subform doesn't work
    By Edwardo in forum Programming
    Replies: 6
    Last Post: 11-29-2010, 08:57 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