• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 338
  • Last Modified:

MS ACCESS TABLE FREEZES WHEN CALCULATING

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
hcp27
Asked:
hcp27
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Try doing a Compact and Repair of the MDB

Tools>>Database Utilities>>Compact and Repair.

mx
0
 
hcp27Author Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
cool
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now