ODBC error
My code is
%@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 Report] where country = 'AD'", ConnectionString
%>
and the error that I get is
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

