If you are not collecting login information for the user to create the connection, I would still create the connection at startup. I would definitely NOT continually connect and disconnect before and after an update. That is too much of a performance hit for me. I would connect if needed, but not disconnect until the user quits the app.
>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
Mark McCasland
Midlothian, TX USA