ASP with MS Access - got it to work but one problem always show up

Hei everybody,

I recently managed to get the connection and created an intranet that manage to show, insert, and edit records from this forum. Thanks for everyone's help.

The problem is after a while when I try to view the asp pages again. it always give me the error page saying that the connection with the database is open or i don't have access even though I checked that the database file hasn't been edit and no browser is open. I couldn't figure out why, and the only way to fix this problem right now is to create a new access file and new connection and everything very tideous.

I am just wondering if this is a normal case and is there any easier way to fix ?

Thanks in Advance

Well, it's not normal

Do you get error messages? Usually this is a symptom of some kind of permission problem, or possibly opening too many database connections.

How do you establish your connection from asp? I like to use the MS Jet 4.0 OLEDB provider for access from a connection string rather than ODBC.

Yes, I use the MS Jet 4.0 OLEDB provider as well for the connection. I only have 2 connections to database though. and yes it is the permission problem too.

Is there a way to prevent this happening again? a friend of mine told me that the connection is not closed yet or is there someway to refresh it.

Thanks Doug

It is hard to say without some details on the problem. You should close and destroy any objects you create in your asp page when you're done with them.

I agree that it sounds like you're leaving a connection open. Access doesn't do well with concurrent connections. Be sure you have something like (where "conn" is the name of your connection object). This makes sure you aren't leaving anything open, (close and destroy, like Doug G said)
HTH

Thanks for the helps.