[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

See also for 'Open MDB files on remote computer in ASP' article:

Compact (compress) mdb database from ASP/VBS script. Two ways to compact MDB database (by DAO and JRO) from ASP/VBS script.

If you like this page, please include next link on your pages:

<A
 Href="http://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>

IISTracer - IIS ISAPI real-time monitor IISTracer is a real-time monitoring tool for Microsoft IIS, which will show/log you what is happenning on IIS server right now. It let's you reveal problems with long-running scripts (.asp, .cgi, cfm...), hang-up states and low resource situations and lets you stop long-running requests (uploads/downloads).	ActiveX User account Manager - Set of simple objects for creating, deleting, and managing user accounts, groups, servers and domains in the Windows NT environment.
Active log file - Hi-performance text file logging for ASP/VBS/VBA applications. Lets you create daily/weekly/monthly log files with variable number of logged values and extra timing and performance info.	ActiveX windows registry editor - Intuitive, easy to use COM interface to windows registry. Set of classes to read/enumerate/modify windows registry keys and values from ASP, VBS and T-SQL.
ActiveX/ASP Multi Dictionary object - Free-threaded hi-speed dictionary algorithm with unique/nonunique keys (map/multimap). Connect to another dictionary object in the same process. Lock and Unlock methods to synchronize tasks (application scope). Share ASP Application/Session objects.	Export DBF/MDB from ASP - Conversion from recordset to MDB/DBF. Direct binary output of MDB or DBF files from ASP pages with one row of code.
Pure-ASP upload - lets you upload files using Pure ASP VBS code (using multipart/form-data and input type=file).	ByteArray - Works with safearray binary data (VT_UI1 \| VT_ARRAY) - save/restore binary data from disk, find, work with code pages, convert to string/hexstring(SQL).
WebChecker - Checks http, https, ftp and gopher internet connections in regular intervals. Lets you monitor web site functionality (uptime). Enables restart or notification on problems.	HTTPLog ISAPI filter - Lets you log incomming/outgoing http header and document data to separate files. Monitor of IIS service input/output.