Prakashpdl
New member
- Local time
- Tomorrow, 02:58
- Joined
- Apr 25, 2020
- Messages
- 27
I have a main form and 5 subforms all based on single table. When I enter a new record in the main form, it says locked by another user. I am the only user. I can not add a new record to the table using main form or subform. I am new to access.please help.
My form is for data collection and I need to update as well as add new data from time to time. Therefore, I have a main form where there is client information and subforms with the different details of the same client. Subforms are linked with the main form (parent child). I have a serch form as well, so I have main form based on query. Main form and all subforms are looking up the same single table. I have several codes behind subforms as well.
I can change the existing data, but can not add new data. Error msg is "could not update, currently locked by another session on this machine". I am attaching the database, can you please help.
My form is for data collection and I need to update as well as add new data from time to time. Therefore, I have a main form where there is client information and subforms with the different details of the same client. Subforms are linked with the main form (parent child). I have a serch form as well, so I have main form based on query. Main form and all subforms are looking up the same single table. I have several codes behind subforms as well.
I can change the existing data, but can not add new data. Error msg is "could not update, currently locked by another session on this machine". I am attaching the database, can you please help.
Attachments
Last edited: