We set up a remote access to our FileMaker database on FM server 12 via VPN. The problem is that we found missing data due to connection drop via VPN. The data entered after the connection is dropped was missed without being committed.
Is it possible to write a script so that the data entered into cache can be forced saved and the user can be warned of the lost of connection and FileMaker can be closed? How do I capture the lost of connection signal from FileMaker server side? How long is the delay and is it feasible to do it onsite remotely through VPN?
Your responses are highly appreciated. Thanks alot.