Everything copied over ok using Web Deploy to copy over IIS settings.
We had a problem with a website that had an Access 2000 backend database.
- Connection issues
- HTTP 500 internal server errror
Connection issuesFirstly 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 errrorThe 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.
Hope this saves people some time