I don't expect anyone here to fix my issue, I'm just hoping for some guidance as to what direction I should look to fix the issue.
I have a database which works fine when only one person is working in it on my office network. The issue described below does not happen when only one person is in the database. The issue only arises when more than one person is working in the database. The curious part is that the issue ONLY happens when I click on (2) buttons in the entire database application
Here is one example: When I click on the LEFT button entitled "All Job Types x Mkt Area -Form" (as shown in Market_Area_Buttons.jpg), the error msg shown in "Access_Error_Msg.jpg" pops up and I have to click through it 3 times until the underlying form (Market_Area_Form.jpg) opens up. Curiously, this does NOT happen when I click the RIGHT button; the underlying form (Market_Area_Rows.jpg) pops open immediately. The data and query used in both forms is identical.
I have read a few other posts on this topic and each individual who has access to my database has their own copy of MS Office 2016 residing on their computer. The main program resides on our office network and they access it using their local MS Access 2016 copy.
Any and all suggestions as to where I might start to look to fix this error would be appreciated. Thank you in advance for any suggestion
I have a database which works fine when only one person is working in it on my office network. The issue described below does not happen when only one person is in the database. The issue only arises when more than one person is working in the database. The curious part is that the issue ONLY happens when I click on (2) buttons in the entire database application
Here is one example: When I click on the LEFT button entitled "All Job Types x Mkt Area -Form" (as shown in Market_Area_Buttons.jpg), the error msg shown in "Access_Error_Msg.jpg" pops up and I have to click through it 3 times until the underlying form (Market_Area_Form.jpg) opens up. Curiously, this does NOT happen when I click the RIGHT button; the underlying form (Market_Area_Rows.jpg) pops open immediately. The data and query used in both forms is identical.
I have read a few other posts on this topic and each individual who has access to my database has their own copy of MS Office 2016 residing on their computer. The main program resides on our office network and they access it using their local MS Access 2016 copy.
Any and all suggestions as to where I might start to look to fix this error would be appreciated. Thank you in advance for any suggestion
Attachments
Last edited: