I wonder why the following code gives me the following problem?
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

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

/showcv.asp, line 14

The code is :

<%
cv_id = request.querystring("ID")

set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("cv.mdb") & ";"
Set rs = Server.CreateObject("ADODB.Recordset")

sqlQuery = "select * FROM cvtable WHERE ID ='" & cv_id & "'"



rs.open sqlQuery, Conn



%>


Thanks

What is the datatype of the ID column? If it's an int, you don't need the quotes around it.
Are you sure that cv_id contains a value?

HTH,

Chris

OR
you try:
response.write cv_id
response.end()

you can see cv_id value,maybe cv_id not get the value

yes and after checking all these things don't forget to check another thing that you are providing the correct name "ID" to request.