Intermittant problems opening Access files on a web server
One of the more popular features on one of our websites is a page where users can upload Access databases that the website will then open (with ADO -- it's an ASP-based application). This mechanism was in place long before I got here, or I would have tried to find a different way to do this. That being said, we're stuck with it for the forseeable future as the users love it, and users indirectly pay my salary.
This was working fine until we moved our sites onto a Win2k3 server (from Win2k). Now, the feature is accessible intermittantly (as in ... it has about 10% availability). The only thing I can tell is that it fails on the Open method of the Connection object. I checked the temp directory to ensure that the ldb files are going there, and I ensured that the right users have write access to that directory. They would have to, otherwise this would never work. The error message comes back as "Unspecified error".
Microsoft technical support hasn't been much help on this issue. Usually they're very helpful, but on this one they didn't have any ideas. I was just wondering if anyone had come across this before.