Can I reuse an ADODB connection in OE0101

[rollover]

I am about to add a db look-up to a third trigger and was curious as to whether or not I could leave a connection open until either the CloseForm or Save triggers or am I inviting problems doing that? I current open, close and destroy the connection once per subroutine.

We are running progression 772 on sql 2000 with flex installed. Some of the CS users will use the same OE screen all day while others have 3 or 4 open at a time.