I usally open a connection at app startup then disconnect at app close. But I'm working on an app where most users don't need a connection. Only a small handful of users that are inserting and updating to SQL need a connection. Question: "Would it be detrimental to Connect right before insert or update then immeditaly disconnect?". Just a note, this app updates SQL for another app. Most users update and read Fox tables.

Your opinion is appreciated.
Regards
Jeff Hart