I have an application with about 30 users, most of whom use the
application on laptops that they take with them. The system is split
into FE and BE. The BE on each laptop is a replica. The system
automatically syncs with the server at their office location each time
they start up the application and they are connected to the LAN and
again when they shut down.
I have experienced occasional database corruption. Having difficulty
tracking down the cause.
Unlikely that it is network connectivity type issues since the database
they access is local to their laptop.
But they could:
...Be closing their laptop without first closing out the
application "gracefully"
...Trying to access the BE database directly
Do others do things like:
...Putting an auto run macro in the BE that shuts down immediately if
opened (without holding down the shift key)?
...Log when users start and normally shutdown an application so you can
tell if the user is not shutting down the application properly
Any other things you standardly do?
My users expect the system to work flawlessly but don't want to spend
any time helping me figure out what caused a problem. sometimes I don't
hear about problems til days later.
Bob