We apologize in advance for the length of this post. The last couple of days have been challenging as we have incurred some data loss with our shared databases. Most likely we are doing something wrong here. Some simple data changes (e.g. updating a date field in a record) on Client A were not getting to Client B, after Client B synchronized the file. The data still was not received on Client B even after Client B quit PanX and reopened the file that should have received the data. Yes, Client B and Client A were connected to the server as indicated by the wifi icon on each computer. Periodic pinging of the server has also been included in our troubleshooting.
Some non-critical, new generation changes (a few lines of benign code) were not getting from Client A to Client B via the server through both a non-critical and subsequent critical new generation. To force the changes to be transmitted from Client A to Client B, we decided to take the file off-line and do a full strength Field Arrangement and Data Types new generation on Client A. When Client B logged back on, the changes (both updated records and additional lines of code added to a procedure) were indeed received on Client B. However, some data records added on Client B were erased sometime along the way when Client B shut down allowing a full strength New Generation to occur on Client A.
We will try to activate the server log as was previously suggested. We have not done so due to lack of time to view the video instructions from last spring, but we now see that we must do something different in order to help solve these problems.
One strange thing that we notice almost always: There is no wifi icon displayed on a form indicating that the file is not connected to the server. However, there is a wifi icon on the Datasheet related to the form. Because the File Menu shows the option of Disconnecting from the Server, and because we have been able to ping the server, we have believed that the clients have been truly connected to the server.
It is probably helpful to know, our clients are NOT connected via a local network, but all of our clients (4 in total number at this point) are connecting remotely. That probably adds another degree of uncertainty to the equation. I am wondering if it is possible that a bad wifi connection at a remote location would allow the lack of synchronization that we have been experiencing?
As always, we appreciate any suggestions or insights.