"Operation is not allowed when the object is closed" error

[ajclifford]

Hello,

I have a few web applications that I have been running on one of our web servers at work and everything is fine. Rearrangements have come about and a change of server is needed. Therefore all the intranet websites/applications on one server were moved onto a new server. But now some of the applications just don't work.

I'm getting the following error in 3 of 8 websites/applications:

Operation is not allowed when the object is closed

The strange thing is I can't find any consistency between the 8 websites. All the HTML only websites are working fine. The 3 websites that are not working all try to access an MS Access database and this is where the error is coming from. However, there are another 2 applications that access MS Access database's but are not suffering from this error :X I'm guessing its some sort of permissions error in the folders/files or IIS itself but I can't seem to work it out. The scripts themselves have not changed so I can rule out any coding errors. If anyone has any ideas or directions I could go with this your help would be greatly appreciated, thanks.

Regards.

 

[dragonwell]

Can you track down the line of code taht generates this error?


Share your knowledge! -

http://www.howisitdone.com

 

[ajclifford]

The error occurs with different code from each application. But it's when they are all trying to use the database object after using it. Yes it's open, and yes it returns rows. I'm positive it's not a coding error because the same code works on the old server, and my local computer. Just not the second server :X