>In gereral, connections should be made for the shortest period possible. What are you using for a backend? Remote Views, SQL Pass Thru? Manage your connections by writing code to minimize connection time.
>
>Tom

As a rule, I use pass-through for my utility connection (open always) and try to limit the application to 1 shared connection. I use remote views for most of my data communications with the SQL server. How about you?

...tim