Solved

MS ACCESS TABLE FREEZES WHEN CALCULATING

Posted on 2009-05-20
4
327 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 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

729 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