Hi all
I have the Access DB which has now been running for 6 months. It consists of a data file with various tables which is saved on a server and local-based access-vba code which links to the data tables and performs the necessary data operations. The system has between 3-4 users at the same time every day.
It normally works fine, but every now and then we are getting an error like this:
"The expression On Click you entered as the event property setting produced the following error:."
This happens randomly, sometimes 2-weeks in between, and sometimes 3 times a day. It is also happening at different parts of the code, but always at a stage when the system is adding, editing or updating a record in one of the tables. Error happens when handling different tables so it is not related to just one table.
I modified the code to avoid having a long time between the .edit/.addnew and the .update lines but the problem is still there.
I suspect it could be related to a loss of connectivity on the network, but I am not sure of this and cannot find a way of proving it.
Any ideas please?
I have the Access DB which has now been running for 6 months. It consists of a data file with various tables which is saved on a server and local-based access-vba code which links to the data tables and performs the necessary data operations. The system has between 3-4 users at the same time every day.
It normally works fine, but every now and then we are getting an error like this:
"The expression On Click you entered as the event property setting produced the following error:."
This happens randomly, sometimes 2-weeks in between, and sometimes 3 times a day. It is also happening at different parts of the code, but always at a stage when the system is adding, editing or updating a record in one of the tables. Error happens when handling different tables so it is not related to just one table.
I modified the code to avoid having a long time between the .edit/.addnew and the .update lines but the problem is still there.
I suspect it could be related to a loss of connectivity on the network, but I am not sure of this and cannot find a way of proving it.
Any ideas please?