Microsoft JET Database Engine error '80040e07' 

Data type mismatch in criteria expression. 

/ckytest/forum/topic.asp, line 1054 

strSql ="SELECT " & strTablePrefix & "ACTIVE_USERS.MEMBER_ID " 
strSql = strSql & " FROM " & strTablePrefix & "ACTIVE_USERS "
strSql = strSql & " WHERE " & strTablePrefix & "ACTIVE_USERS.MEMBER_ID = '" & TMember_ID & "'"
set rsOnline = Server.CreateObject("ADODB.Recordset")
rsOnline.open  strSql, my_Conn, 3

response.write "Status: "
if rsOnline.EOF or rsOnline.BOF then 
' do nothing
else
if  Members_MemberID = rsOnline("MEMBER_ID") then
response.write "Online"
else
response.write "Offline"
end if 
end if
rsOnline.close
set rsOnline = nothing