Maintain Active Connection

[rukie]

Hi Guys,
Maybe this has been asked before but I couldn't find it...

I have an Access 2007 Database I'm programming. The tables will be linked lists with SharePoint, but I also gather data from another database from JD Edwards (Now an Oracle product). This uses separate log in information. Using a .UDL file I keep the connection information (minus username/password).

In one sub form it gathers information from this second system, but each time I use the form the connection has to be reestablished (and username/password have to be reentered). How can I make this connection more permanent? Should I initate the connection on a hidden form, or is there a better method?



Thanks!

[rukie]

More details:
So I'm reading about session pooling/etc. The issue I have is when I close a subform and re-open that subform, I have to enter credentials again. I don't want to re-enter credentials for the Oracle Server each time..
Thanks!