Tuesday, 3 July 2012

We had a problem with a website that had an Access 2000 backend database.

Connection issues

HTTP 500 internal server errror

Connection issues

Firstly it wouldn't connect at all. We found that this was due to the Win 2008 not having the correct Jet drivers. (It has changed to ACE).

HTTP 500 internal server errror

The next issue was that some pages were showing Server 500 errors when users clicked on them. It looked to be when users were trying to modify the database. In one case the issue was due to the database file becoming read only when it was moved to the new server. and in the other case it was because the lock file (.ldb) file had been copied over with the main database file. Once the lock file was deleted it all started to work as it should.