Discussion Locked

Access "Run Time Error 2001"

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

An Access (2002) form that was previously working fine now generates the error:
"Run time error 2001: You cancelled the previous operation"
This began after a change in code that is unrelated to the code that debug points to.
Any idea what this error means? Help was no help.

4 replies

by chrissaw

Hi Gregory,

I received a similar error in an Access 95 database. The way I resolve it was to copy the form under another name, delete the original form, compact the database, renaming the copied form to its original name and compact it again.Hope it could help.
Christian

by gregoryd

Thanks Christian
This was basically the same answer that I finally got from Microsoft on the assumption that the form was corrupted. In my case, the form wasn't corrupted. The problem was an SQL statement with a "Where" clause that evaluated to Null. Once I corrected that, the problem was solved. Not exactly a meaningful error message is it!
Greg

This discussion is closed to new replies.