How to use ASP to access the MDB Access database file on a remote computer application tips

If you use an ODBC connection (DSN method or otherwise) to an MDB file on a remote computer, this will produce an error:
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 ' roughly means that the file may be accessed by another user or without sufficient permissions.

Here are two ways to avoid this error:

Way A. Using the DAO engine to access
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)
Mode B. ADO + Jet OLE DB provider method
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)
To determine that you have sufficient access rights to run an ASP page to access an MDB file on a remote computer, you need to log on to the remote computer before you can access the MDB file and add the following code:
Set UM = CreateObject ("Usermanager.server")
Um. LogonUser "Account", "Password", "Domain"
...
Open Database
...
Um. RevertToSelf