Problem with Access DB & Web Page

[Daniel Lamarre]

Hi everyone,

I figured this would be the best place to post since I'm not exactly sure where the problem is originating from.

Here's my problem: I set up an ASP enabled web page that works with an Access DB. The connection is configured with ODBC (MS Access Driver).

The setup worked perfectly before but I had to re-install W2k3 because of a hardware failure. The Web directory has not been changed. When users go around and use the web site, everything works perfectly. At the point where I access the database from a local session (on the server) everything stops working on the web site. They get a HTTP 500 error, no more information.

I figure it's a security problem or something like that, but the only way to make it work is to restart W2k3. Shutting down IIS and restarting it won't help. The database isn't locked or anything. All pages within the web site use the database except the login page, which I will occasionaly get after this error shows up; it will not go any further.

Thanks for your help!