Open MDB files on remote computer in ASP

If you use ODBC connection (DSN or DSN-less) to file on remote computer (UNC path), OLEDB raises next error :

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.

      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.
      You can also logon to another NT user account with the rights before openning connection :

'http://www.motobit.com Set UM = CreateObject("UserManager.Server") UM.LogonUser "Login with the rights", "Password", "Domain" ... open database ... UM.RevertToSelf

Copyright and use this code

The source code on this page and other samples at https://www.motobit.com/tips/ are a free code, you can use it as you want: copy it, modify it, use it in your products, ...

If you use this code, please:

1. Leave the author note in the source.

2. Link this sample from you page.

<A
 Href="https://www.motobit.com/tips/detpg_ropenmdb/"
 Title="Two ways to open DSN-less connection
	to MDB file on remote
	computer from ASP/VBS script."
>Open MDB files on remote computer in ASP</A>

Open MDB files on remote computer in ASPMOTOBIT.COM

See also

Copyright and use this code