I'm not noticing any kind of speed issue when I save. Do you belive I'll notice degredation once a few hundered people are connecting and disconnecting? I don't think I'll put it to the test, but I am curious.

Regards
Jeff

>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