code error with Access

[madhuri.t]

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.

[benbramz]

• check the location of the file
• check the permissions for that file / folder