MS Access database remains open in ASP.NET?

[WQ]

Folks,

I am sure this is a simple one for you gurus. I am rather new to ASP.Net.
I have setup a connection string to an MS Access database using web.cfg.
Somehow, some component of ASP.Net keeps the database opened (I can see the
..ldb file) even when the user has physically logged off (session.abandon).
Ideally, I would like to achieve traditional ASP type environment, where the
connection opens only when the page is being processed.

I would appreciate your comments to fix my issue.

Thanks.

Walt.

[Cor Ligthert]

WQ,

Best practise with ADONET is to open and close everytime your connection.

When you are using the dataadapter, you do not even have to create it. The
dataadapter does it for you, in that case it closes it automaticly.

For this kind of AdoNet questions is the best newsgroup.

Microsoft.public.dotnet.framework.adonet

I hope it gives some idea's

Cor

"WQ" <no*****@no-reply-mail.com>

I am sure this is a simple one for you gurus. I am rather new to ASP.Net.
I have setup a connection string to an MS Access database using web.cfg.
Somehow, some component of ASP.Net keeps the database opened (I can see
the
.ldb file) even when the user has physically logged off (session.abandon).
Ideally, I would like to achieve traditional ASP type environment, where
the
connection opens only when the page is being processed.

I would appreciate your comments to fix my issue.

Thanks.

Walt.