?
Solved

MS ACCESS TABLE FREEZES WHEN CALCULATING

Posted on 2009-05-20
4
Medium Priority
?
329 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 75
ID: 24435329
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
ID: 24435963
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
ID: 24436000
cool
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

770 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