I've developed an application that uses a main form with a PersonID as PID with subforms for appointments. It is now installed on a network with 4-5 people updating it at a time. The problem is that when they run the filter by last name they could get 72 persons and they use the navigation buttons to move to the correct person and update their appointment date/time. Occasionally the PID from the main form and the PID (foreign key) on the appointments do not match. Then, when they update the appointment date/time it updates the wrong appointment.
I have been unable to duplicate this problem on my laptop which is significantly faster and with more memory than the computers on the network. They may also break into code with no obvious errors and when I press F5 I get no errors. Has anyone experienced this problem and solved it? My hypothesis is that it is a network performance based. If the system timeout is set at 30 and the network can not keep up with the paging between records it times out and does not update the subform record to the correct subform. Currently we are running this app on a single state of the art laptop to test the hypothesis that it is a network performance issue.
-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------
I have been unable to duplicate this problem on my laptop which is significantly faster and with more memory than the computers on the network. They may also break into code with no obvious errors and when I press F5 I get no errors. Has anyone experienced this problem and solved it? My hypothesis is that it is a network performance based. If the system timeout is set at 30 and the network can not keep up with the paging between records it times out and does not update the subform record to the correct subform. Currently we are running this app on a single state of the art laptop to test the hypothesis that it is a network performance issue.
-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------