Printable View
What's considered the best way to declare db connections? Declare them global in a module, so they're available everywhere, but always in memory, or declare them in each sub & function, increasing overhead but saving memory? Or declaring them in a module, but instantiating in each sub?
It may not be a big savings either way, but I have to deal with some machines that only have 32 mb ram. And I just like cleaner, more efficient code. Thanks.
Check out Microsoft's Application Programming Blocks (I think that's what they are called - and I don't have a link handy). One of the blocks available is a db connection management piece, you jsut supply a couple of pieces of data and it takes care of creating the connection for you. I haven't used it personaly, but I've heard good things about it.
TG
I've looked at that, but I think it says you need VS 2003, and I have 2002.