The requested resource is in use.

[jytioh]

I'm having "The requested resource is in use" problem on some of my asp pages. Those affected are the ones with recordsets read from access database. Pages not linked to database are not affected. Please advise on what I should do in order to solve this problem.

Thank you.

[russell]

ms access can only be utilized by one user at a time. if it is open via the access gui, it won't be available for any other purpose. (1) don't open it other than via asp, (2) else, use a more robust db (mssql, mysql, oracle, db2 etc.)

sum up: if you use access for asp, don't allow anyone to touch it other than your asp.

[jytioh]

Based on my latest observations, it is working on recordsets when i refresh but it will fail when I try to login to any password protected area.

[russell]

are you explicitly closing and destroying all of your objects? how many users on your site?

[jytioh]

how do i explicitly destroy or close objects on the server?

[russell]

rs.close
set rs = nothing
db.close
set db = nothing

etc.