I have a database I developed using Access 2003. The data resides on a network server, and the front end contains forms, queries, etc. resides as an mde file on the users’ pc’s. There are about 15 users that can be using the application at a given time. There is no mdw file with the application.
There application has 4 forms. One form is a log-on form. When the user logs in successfully, there is a main menu to select which form to launch. The form which is experiencing an issue is a form that uses a main form linked to a subform to input data into the database. The data input into the main form updates Table 1 and the data input into the subform updates Table 2.
Users are sometimes experiencing an issue and getting a message stating, “Could not update, currently locked” when trying move from the main form to the subform. I have code to save any main form edits in the main form's lost focus event, as follows:
I also have code in the main form's after update event to save any edits made to data on the main form, as follows:
Can any expert please tell me if this code may be what's causing the issue the users are experiencing? This code is in the form to help automatically save edits in case they don't hit the save button on the form. The users have been told to "save often", and that seems to be helping. Any ideas would be appreciated because I am pretty lost and frustrated with trying to solve this problem because I've tried and still not resolution. Thanks experts.