Microsoft OLE DB Provider for ODBC Driverserror '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.
You can avoid the error - ASP and ActiveX supports two ways to open DSN-less connection to MDB file (or connection to MDB file from another computer).
1. DAO database (only for small load)
Dim File, Conn, RS Const ReadOnly = False File = "\\server\share\file.mdb" Set Conn = CreateObject("DAO.DBEngine.35").Workspaces(0).OpenDatabase(File,,ReadOnly) Set RS = Conn.OpenRecordset(SQL)2. ADO + Jet OLE DB provider
Dim Conn, RS Set Conn = CreateObject("ADODB.Connection") Conn.Provider = "Microsoft.Jet.OLEDB.4.0" Conn.Open "\\server\share\file.mdb" Set RS = Conn.Execute(SQL)Be sure that the user running ASP (probably IUSR_...) has NT access rights to the share and the database.
Set UM = CreateObject("UserManager.Server") UM.LogonUser "Login with the rights", "Password", "Domain" ... open database ... UM.RevertToSelf