Dan, I'd be very interested to know if #2 solves your corruption problem.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Tuesday, November 05, 2013 11:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - compiled apps best practice 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
