General discussion

  • Creator
    Topic
  • #2297227

    Access freezing

    Locked

    by intern3 ·

    I do data entry with my company, and something strange is happening to our Access 2000 database. When I run a query on a particular field in one of the databases, I cannot resize any of the columns or scroll too quickly up and down, or the area becomes filled with white, the computer freezes up, and upon bringing up task manager, the cpu is at 100%. I then have to crash Access in order to use it again. Also, after trying to close any queries, the following message pops up –“This action will reset the current code in break mode.” And in order to get out, I again have to crash Access. Our admins just synchronized all the versions of Office in our office to 2000, and we have ran anti-virus software, but the problem is still occurring…Any ideas?

All Comments

  • Author
    Replies
    • #2685900

      Reply To: Access freezing

      by intern3 ·

      In reply to Access freezing

      Point value changed by question poster.

    • #2700351

      Reply To: Access freezing

      by eschlangen ·

      In reply to Access freezing

      I have had a similar problem when the query uses a user defined function and the data was inconsistent with the function or resulted in an infinite loop inside the function. There’s not enough info to know whether this is your problem but the cpu at 100% indicates that it might be (caveat: Access 97 showed 100% in the task manager all the time.)

Viewing 1 reply thread