Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[mmchenney]

Getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/regions/webpages/HHSC_Voice_Consolidation/UpdateDelete.asp, line 15

My Code:

<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<!--#include virtual=&quot;/regions/Connections/regional_personnel1.asp&quot; -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = &quot;1&quot;
if (Request.QueryString(&quot;Select&quot <> &quot;&quot then Recordset1__MMColParam = Request.QueryString(&quot;Select&quot
%>
<%
set Recordset1 = Server.CreateObject(&quot;ADODB.Recordset&quot
Recordset1.ActiveConnection = MM_regional_personnel1_STRING
Recordset1.Source = &quot;SELECT * FROM HHSC_VoiceInventory WHERE region = '&quot; & Session(&quot;region&quot& &quot;' ORDER BY city ASC&quot;
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = -1
Dim Repeat1__index
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>

 

[Dorff]

Check UltraDev forum... Ryan
rmindorff@hotmail.com