I am struggling with what appears to be a simple issue. I have a straight Windows 2000 network with 2 servers; one using Active Directory and another server running an ASP application. The ASP application is attempting to access data on the AD server via a mapped drive setup in DSN, but gets the following error:
HTTP 500.100 – Internal Server Error – ASP error
Internet Information Services
————————————————–
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[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.
/innovetadev2/PandVReports/index.asp, line 16
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; AT&T CSM6.0; T312461)
The ASP line of code mentioned is:
Set objConn = Server.CreateObject (“ADODB.Connection”)
objConn.Open “DSN=PartsandVendor”
What permissions/USER account needs to be set for the application to be able to access this Access DB?
Curt