A global connection object is the key, but you probably shouldn't just open
it and hold it until the application closes down.  This takes up a lot of
resources, and will require one server connection license per workstation
connected.  A better solution is to open the connection at the latest
possible time before use, then close it immediately after use.  Even better
would be to use a DCOM object that can pool connections for many users.
This way, if you have 100 users, you may be able to get by with 5 or 10
licenses, rather than having to purchase 100.  It will also be less load on
the client machine and less network traffic.



------------------------------------------------------
Christopher Tacke, MCSD
Associate
Rubicon Technologies
(xxx) xxx-xxxx  Ext. 319