Connection object

[jtseltmann]

Just looking for a little tip as to what is a better way to go...Is it better to open one global connection to the Current Project Connection or open and close the connection as needed? I have always done it where I open and close the connection as needed but I was curious if one single open and setting a global object would be better?

Anyone have any thoughts on this? thanks for any tips.

 

[Golom]

Difficult to generalize too much.

I usually have a global connection which reduces the amount of code that I need to place in individual Subs / Functions, etc. It also gives me a single point of control so that I don't have to find and change many different instances of the connection string.

On the negative side, if I need different connection properties for different parts of the application then I will go with the open / close in a particular routine.

 

[JoeAtWork]

I never open my own connection, I just use CurrentProject.Connection

Joe Schwarz
Custom Software Developer

http://www.plandev.net