Open MDB Files on a Remote Computer   
 
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.psacake.com
    Set UM = CreateObject("UserManager.Server")
    UM.LogonUser "Login with the rights", "Password", "Domain"
...
open database
...
    UM.RevertToSelf

 

My3C's
perrychicker
It's easy... it's a PSACAKE!
Back | Tell A Friend | Search this Site
© 1998 - 2010 psacake.com
Version 3.23

Send me One Million FREE Guaranteed Visitors