Results 1 to 3 of 3
  1. 04-23-2019, 02:07 PM #1
    mcucino
    mcucino is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Location
    Providence, RI
    Posts
    74

    Query opens instantly, form takes 5 minutes

    I have a query that loads instantly when opened (less than 2 seconds) but when I make a super simple, no code datasheet form to view it, it takes over five minutes to load. Any idea why?
    Reply With Quote Reply With Quote
  2. 04-23-2019, 02:33 PM #2
    isladogs's Avatar
    isladogs
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    What is the SQL for the query / form?
    Is something else happening in the background?
    Are there a large number of records / fields involved?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer
    Reply With Quote Reply With Quote
  3. 04-23-2019, 02:35 PM #3
    June7's Avatar
    June7
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Not without examining data and query and form.
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. using a UDF in a query that takes column values? Is this possible?
    By CodeLiftSleep in forum Access
    Replies: 9
    Last Post: 10-19-2017, 09:20 PM
  2. how do i update data instantly between two front end databases
    By DiGamer in forum Access
    Replies: 8
    Last Post: 10-04-2014, 10:21 AM
  3. Converting Minutes from a Query to Hours:Minutes on a Report
    By Nuke1096 in forum Access
    Replies: 4
    Last Post: 06-12-2013, 10:20 AM
  4. The name of the field takes the name of its source query,
    By jamal numan in forum Access
    Replies: 2
    Last Post: 10-12-2012, 02:33 PM
  5. Access Takes my Query and Alters it!
    By dso808 in forum Queries
    Replies: 2
    Last Post: 10-01-2010, 03:45 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums