Results 1 to 4 of 4
  1. #1
    bell is offline Advanced Beginner
    Windows 7 64bit Access 2002
    Join Date
    Feb 2015
    Posts
    37

    Access 2003 Freezes

    Hi all,

    I have been experiencing a problem recently with Access freezing.

    It happens on random, sometimes when I open up a form in Design View, sometimes when I click a button on a Form, sometimes when I am opening up a table to view the data. It doesn't freeze every time I do these actions, but enough to start annoying me. It doesn't crash, but it takes a minute or so to get out of the freeze.



    My tables hold a lot of records, 7000+. Could this cause it to freeze? Anyone else experience freezing problems?

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,900
    7000 records is not that much (unless you have something like 255 fields).
    What is the actual size of the database? Access has a 2 GB limit. If you are approaching that, that could affect performance.
    Also, have you tried "Compacting and Repairing" your database. That should be done somewhat regularly to keep it running "lean". Especially if you have deleted a lot of data.
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  3. #3
    bell is offline Advanced Beginner
    Windows 7 64bit Access 2002
    Join Date
    Feb 2015
    Posts
    37
    Hi thanks for your response! I am still fairly new to Access so I didn't know about the Compacting and Repairing button.

    The size was about 73,000KB BUT after running Compacting and Repairing, the size went down to 7KB (wow didn't realize it could help that much). I'll continue working with it and see if that solved my problem.

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,900
    Yes, when you delete data or objects in Access, they really aren't deleted from the database until a "Compact/Repair" is run.
    They are just "marked" for deletion. The Compact/Repair "flushes" it from your database.
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

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

Similar Threads

  1. Access freezes up and crashes
    By CompTechRx in forum Access
    Replies: 5
    Last Post: 11-01-2011, 02:53 PM
  2. Forms Freezes After Record Is Updated
    By toonz in forum Forms
    Replies: 1
    Last Post: 10-04-2011, 01:09 PM
  3. Design view 'freezes' in Access 2010
    By dknowle in forum Access
    Replies: 1
    Last Post: 08-31-2011, 11:05 AM
  4. Access Freezes at startup
    By pokerim in forum Access
    Replies: 1
    Last Post: 07-20-2010, 06:28 AM
  5. Access freezes when opening forms
    By thorpef1 in forum Access
    Replies: 0
    Last Post: 01-04-2010, 04:48 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 - Senior Forums