...are attempting to change the same data at the same time." Not true.
This error occurs in a pretty basic point-of-sale module, just at the point when a product is selected from a dropdown list on a subform. We've done exhaustive testing and believe me, it's frustratingly random - yet all too frequent. It's killing us. #Error #Error #Error shows up in all the fields & you have to tap dance your way out of the program.
We have a FE/BE system. We don't have a memo or an OLE field on the form that causes this error. Our Access 2k program runs on 98, ME, and 2000 platforms in single-user environments. We updated Jet engine with the latest patch, installed all service packs and releases. We have run tests for hours but we can't reproduce the error on a certain sequence or under certain conditions. We know the db is corrupted once the error shows up, because it grows 50%in size after the error. At times we are able to go on working on the program as nothing has happened whereas other times it keeps giving the error and forces us to exit the program each time.
It is now happening on a regular basis, so it's not a reasonable solution to exit, Compact & Repair. We are out of ideas. Please HELP!