Hi
I have a data access layer that provides static functions between my
business logoc and an Access database. The connection string to the
database never changes.
Currently I carefully open and close a connection to the database at
the begining of each method in the dataacces layer. But am not sure
this is the best method, I went this way because i read somewhere in
web apps connections should be kept open for as short a period as
possible.
If i have multiple sessions on the go on the web server i worry that
there are lot of connections opening and closing that could be shared.
Can anyone advise
Thanks
Tom