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

[Rheal]

Hi
Can someone help me. My error is :
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/add.asp, line 73

my codes are

<% dim DataCon, rsRec, strSql, strSql2, rsRec2
set DataCon = server.createobject("ADODB.Connection")
DataCon.ConnectionTimeout = 10
DataCon.CommandTimeout = 30
DataCon.Open "DBQ=" & Server.mapPath("booking.mdb") & "; Driver={Microsoft Access Driver (*.mdb)}; "
Set rsRec = server.createobject("ADODB.recordset")
rsRec.CursorType = 3



strSql = "SELECT fldDescription FROM tblTimeSlot WHERE fldSlotID =" & request.querystring("slot")
rsRec.Open strSql, DataCon%>

[Laharl]

You're in the wrong forum. Perhaps you meant the Access forum?

[acoder]

I'm guessing this is an ASP question because of the code generating the query. If not, could a moderator move it to the correct forum.

Rheal, as well as posting in the most relevant forum, could you also ensure that code is posted using code tags. See How to ask a question. Thanks.

Moderator.