I am trying to figure out the best practice for compiled apps. I have a compiled app that users open. It is an external form file that is ran.
The question is should I: 1. connect to the database when they open the app and leave it connected until they close the app. or 2. open the app and stay disconnected. When they click on something on the app, connect to the database, process, and when it is done disconnect. Right now I use option 1 but from time to time the database gets corrupted. I am thinking maybe to do option 2 but do not know how that will work or if it will solve the corruption problem. TIA Dan Goldberg
