Results 1 to 6 of 6
  1. #1
    imorgan22 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    10

    Slow Form

    I am using access for my budget system and it is very slow. The main form has several subforms and it takes a long time to display the form. Any suggestions on how to make this faster? I like access and find it flexible but my users are upset because of the speed. I keep telling them you can't expect to see all that information and the form will come up in seconds.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,629
    I also have a couple of form/subforms arrangements that take longer than I would prefer for them to load. The subforms are distributed on pages of a tab control. The only options I can think to speed up would be to not load the subforms when the main form opens but to programmatically load them when page of tab control gets focus or to have the subforms open independently when needed which would make data synchronization more difficult.
    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
    imorgan22 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    10
    I tried convincing them to do that but they want to see all the information at the same time. thanks for the suggestion thought. My main db is oracle. I changed all the table to oracle tables and tried using pass-through querys and it is even worse. anyone have any suggestions to make the queries run faster. maybe that would help speed it up.

  4. #4
    Bob Fitz is online now Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,527
    I found that the technique explained here http://www.granite.ab.ca/access/performanceforms.htm worked very well.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    Bob Fitz is online now Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,527
    Keeping an open connection to the back end can also help. See "Always Keep a Connection Open to the Back End Database While Your Application Runs" at: http://www.fmsinc.com/MicrosoftAcces...dDatabase.html
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,629
    I tried the open db connection method and not seeing any appreciable change in performance. My most complex form still takes 10-20 seconds to open depending on the machine. And it was slowest on mine running the new code compared to others without the new code. Go figure!

    I am not familiar with the Static variable declaration but I don't think it is acting as described in Help, at least not as I expected. The variable does not persist when the procedure ends. So I declared a global variable in a general module instead. The variable does persist but still no improvement.
    Last edited by June7; 09-05-2013 at 03:08 PM.
    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. Complex Expressions on Form Too Slow - Any Better Way?
    By accessbeginner12 in forum Forms
    Replies: 4
    Last Post: 03-29-2013, 03:47 PM
  2. Slow Form Blues
    By mickeymatos in forum Forms
    Replies: 2
    Last Post: 12-12-2012, 03:15 PM
  3. Replies: 1
    Last Post: 08-11-2011, 06:22 AM
  4. Form Loading Slow From the Shared Folder
    By injanib in forum Forms
    Replies: 2
    Last Post: 06-25-2011, 03:45 AM
  5. Replies: 0
    Last Post: 02-09-2007, 09:20 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 - Senior Forums