Solved

MS ACCESS TABLE FREEZES WHEN CALCULATING

Posted on 2009-05-20
4
320 Views
Last Modified: 2012-05-07
I have a few co workers that use MS Access 2003 to input and delete inventory from a small database. I notices that it freezes up and says calculating when trying to delete an entry and will resume the second you press ctrl-alt-delete. If you leave Task manager open and just minimize, Access runs fine and never freezes up when tryin to delete and entry. I'm tryin to figure out why its stable with Task Manager open.
0
Comment
Question by:hcp27
  • 2
4 Comments
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Try doing a Compact and Repair of the MDB

Tools>>Database Utilities>>Compact and Repair.

mx
0
 

Accepted Solution

by:
hcp27 earned 0 total points
Comment Utility
I looked and noticed that the particular user that was having problems didn't have Office 2003 Service pack 3 applied. So i downloaded and installed it and it fixed the problem.
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
cool
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now