Hi,
I am trying to access MS-Access Database on a remote server with the code below.

<%@LANGUAGE="VBSCRIPT"%>
<!--#INCLUDE virtual="/common/pricelist.asp"-->
<%
Dim ConnectionString
dim oConn

ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" &_
"DBQ=\\Server167\BusOps\Maint_ Ren_ Web_ Page_ Upload_DB.mdb;DefaultDir=;UID=;PWD=;"


Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "Select * from [Maintenance Renewal RAW Report] where country = 'AD'", ConnectionString

%>

and it gives me the following 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.

/Renewals/testfeb.asp, line 13


please suggest, how should I reslove it.

does your provider allow remote database access ? are you accesing this from another website ?

i know we dont allow remote access from outside of our servers.
you have to be within the same account to access a database.

your provider might have it blocked

And perhaps not a high chance of success but you may want to check this out:

Why can't I access a database or text file on another server?
http://www.aspfaq.com/show.asp?id=2168