I have one table that has data that I want the user to access through
two different forms .The initial data entry (create record which enters data in field 1,2,3)work will be done in the in main form but the later updates (updates to filed 3,4,5) to the record will be done through the second form. Ocassionally the user needs to switch between the forms to complete their task. I am getting an error when I try to open the second from when the first form is already open.
The table 'xxxxx' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.
How can I remove this exclusive lock from the table so that I can open both the forms at the same time.
I am using access 2007 and I am not a developer. Nothing is done using macro or modules.
two different forms .The initial data entry (create record which enters data in field 1,2,3)work will be done in the in main form but the later updates (updates to filed 3,4,5) to the record will be done through the second form. Ocassionally the user needs to switch between the forms to complete their task. I am getting an error when I try to open the second from when the first form is already open.
The table 'xxxxx' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.
How can I remove this exclusive lock from the table so that I can open both the forms at the same time.
I am using access 2007 and I am not a developer. Nothing is done using macro or modules.
