Unanswered: problems when trying to open access database
I have got this weird problem with connecting to an access database within our intranet.
Here is the situation.
Server1 is the intranet server with the asp pages. Server2 is a server on another location where the database resides.
I've made a drivemapping on server1 which points to a share on server2. I can open the access database if I doubleclick
I also setup an IUSR account on server2 with the same name and password and I also checked the share permissions and
the ntfs permissions, which are, for testing, full control for this IUSR (it doesn't matter anyway, because it's not
reachable for the outside world).
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.