Okay, I created a very cut down version with gibberish data, so I could upload it. Ignore any errors outside those generated by the following steps.
The steps to recreate the problem:
1. I open the db
2. Alt + F11 and make any change to the code. No problems.
3. Click on <Show Toolbar>
4. Alt + F11 and make any change to the code. Still no problems.
5. Click on <Uncovered Items>
6. Alt + F11 and make any change to the code. Still no problems.
7. From the ‘Analyst’ drop down, select ‘RB’
8. From the ‘Time and Exceedance’ drop down, select ‘All open items’
9. You should see one record displayed in the top subform
10. In the bottom right subform, type a 12 digit value into the QIC field e.g. 1234567890-12
11. Tab out of that field
12. The VB code errors. If you try to make any changes to it, you get the error message “Run time error 3734: The database has been placed in a state by user ‘Admin’ on machine ‘{my PC name}’ that prevents it from being opened or locked”
Got help, thank you!