Results 1 to 2 of 2
  1. #1
    fluppe is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    48

    nested queries extraordinary slow

    Hello,

    i wanted to ask if it is commonly experienced, that nested queries are veeerryyy slow in access.
    I have written some queries directly in SQL view that use other queries, and it is really slow, although there is not much data or other things.


    My access doesn't respond for 2 minutes and then the query finishes. Is there something special about access that makes it slow in that case ?

    Thanks in advance,

    fluppe

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    It could be the query action,
    or network connection,
    or database connection.

    If the query is complex, they can run slow.

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

Similar Threads

  1. Update queries sometimes very slow
    By GregL65R in forum Programming
    Replies: 3
    Last Post: 12-05-2013, 05:42 PM
  2. split database queries slow fyi
    By survivo01 in forum Access
    Replies: 1
    Last Post: 08-24-2013, 01:08 AM
  3. Complicated Nested Queries/References
    By Epidural in forum Access
    Replies: 6
    Last Post: 05-08-2012, 02:06 PM
  4. Nested IIF
    By Oldie in forum Queries
    Replies: 1
    Last Post: 02-17-2012, 06:04 AM
  5. Triple nested queries
    By niculaegeorge in forum Queries
    Replies: 5
    Last Post: 07-25-2011, 07:04 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