Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    alyon is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    89

    Access Running Slow. Help?

    Hello, I have an Access 2010 database. It has quite a few reports, queries, a few forms, much code, and a lot of imported images. The database is split as there are many different users, and I often compact and repair it. I had it set to compact and repair on close but it caused issues, so now I just do it manually daily. It is 42,000 KB, and it runs ridiculously slow. I cannot decrease the size or delete any parts or functions within as all are necessities. I greatly appreciate any suggestions to fix the issue. Thank you in advance for your help! -alyon

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Can you be more specific about what is slow.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Here's some suggestions in a link: http://www.granite.ab.ca/access/performancefaq.htm

  4. #4
    alyon is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    89
    Bob, to be more specific about what is slow. I'm not exactly sure, as my co-workers use the program not me.. It's pretty much just when you're typing it'll freeze up and give you the thinking cursor, same with closing it -- it freezes terribly when closing. when you start a new record.. it gives you the waiting cursor. I understand there's a lot going on in the program, and it does need time to think.. but the waiting cursor is not a few seconds, it freezes for minutes. Also, searching within the program is extremely, extremely slow. RuralGuy, I looked at your link (which has a bunch of suggestions).. I can't change the virus protection software, or that we're on a wireless network, but I did see the BeginTrans & CommitTrans for vba code... does anyone happen to know if that would be helpful? Thank you both for your assistance!

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Just for the record: Access does *not* do well on a wireless network! Wireless can cause corruption as well.

  6. #6
    alyon is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    89
    I figured it didn't from the tips you posted, but I can't do anything about that.

  7. #7
    alyon is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    89
    Bob, I guess I should also add that it often shows "not responding" with the waiting cursor.

  8. #8
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Allan's link to granite is an often referenced link for performance.
    Here's one from FMS http://www.fmsinc.com/MicrosoftAccess/Performance.html

    Do you have personnel with network experience. Can they provide any info related to issues/problems with your network?
    Has performance always been "questionable", or has there been some event that has triggered poorer performance?

    Did you have issue during development?

  9. #9
    alyon is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    89
    Our network was slow at times, but our internet was upgraded, so that runs rather quickly now. I had no problems when developing the programs, and in the beginning it ran rather quickly. As it got bigger, and more added, and especially after splitting the database.. I've noticed it's much slower.

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do you at least have a Persistant Connection?

  11. #11
    alyon is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    89
    Yes, I have a persistent connection.

  12. #12
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Does this system use the Internet as well? That can fluctuate in speed as well and generally just gives consistantly poor performance for Access.

  13. #13
    alyon is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    89
    Does what system use internet as well? I mean I know it's wireless, and that's not great for access.. but I can't fix that. I need something I can change, something I can fix to deal with the problem. So internet connection, whether fast or slow, or wireless or not seems irrelevant, as I cannot change it.

  14. #14
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    A few questions:

    1. Does each user have their own copy of the Front End DB or is there just one copy that everyone runs?
      • Sharing the same DB (or the same Front End in the case of split DBs) causes a HUGE performance penalty and can create conflicts, locking some people out of the program, etc. I'd recommend that you put a separate copy of the Front End on each computer.

    2. Do you regularly run a Compact and Repair on the Front Ends too or just on the Back End?
      • If the Front End isn't regularly Compacted, it can get just as messed up as the Back End can. If your users can't perform their own Compact and Repairs (if they have the Runtime version for example), the easiest thing to do is put a "fresh" copy of the Front End on the network and then copy it to their computers (replacing the copy they already have) each time they log on.

    3. Is the database stored somewhere on the local network or do you have to connect to the internet (for example, over a VPN or to a server at a remote location) to run it?
      • Access is HORRIBLE over low-speed connections (and even a fast internet connection is considered slow by regular network standards). Make sure it's on the local network and not being accessed over the internet.

    4. Are you using UAC (does Access ask you to log in before you can open the DB)?
      • Sometimes UAC can cause performance issues. The only way to check if this is a problem is to disable it and see if the issues go away. If they do, you'll most likely need to find another way to implement access control/security.

    5. How often has the VBA Code been updated since the last time it was decompiled?
      • Access doesn't always remove old code/modules properly when you make changes. Sometimes, this can cause lockups and stability issues if it gets bad enough. Try decompiling the Front End DB once and see if that helps (MAKE A BACKUP FIRST!!!). This can also decrease the size of the DB


  15. #15
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    The tips on this link worked well for me with a multi user db: http://www.granite.ab.ca/access/performanceforms.htm
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access running very slow
    By k11ngy in forum Access
    Replies: 1
    Last Post: 10-12-2012, 08:09 AM
  2. Replies: 3
    Last Post: 04-03-2012, 05:27 PM
  3. Reports running slow
    By kwooten in forum Reports
    Replies: 2
    Last Post: 12-02-2011, 03:29 PM
  4. Query running VERY slow
    By purple_kittykat in forum Queries
    Replies: 4
    Last Post: 07-31-2011, 12:40 AM
  5. Replies: 2
    Last Post: 01-19-2011, 10:19 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