Hi, I have an Access Database, with users identified by a user ID number, which is set for AutoText(number?). I&#039m having a lot of trouble getting info from the database using the usernumber as reference. My code and the error message I keep getting are below:<BR><BR>&#060;%<BR>set ConnObj = Server.CreateObject("ADODB.Connection")<BR>Set RstObj = Server.CreateObject("ADODB.Recordset")<BR> <BR>RstObj.CursorType = 0<BR>RstObj.LockType = 1<BR>ConnObj.Mode = 1<BR>If Request.Form = "" then %&#062;<BR><BR>&#060;HTML&#062;<BR>&#060;head&#062 ;<BR>&#060;title&#062;&#060;/title&#062;<BR>&#060;/head&#062;<BR>&#060;body bgcolor="white"&#062;<BR><BR>&#060;H1&#062;Input your User Number.&#060;/H1&#062;<BR><BR>&#060;FORM Method=POST&#062;<BR>&#060;INPUT name="no"&#062;<BR><BR><BR>&#060;INPUT type=submit&#062;<BR>&#060;/FORM&#062;<BR><BR>&#060;/body&#062;<BR>&#060;/HTML&#062;<BR><BR>&#060;%else<BR>name=Request.Form ("no")<BR>ConnObj.Open "sandra-site" <BR>SQLstatement = "SELECT DISTINCTROW resumetable.* FROM resumetable WHERE (((resumetable.no)=&#039" & name & "&#039))"<BR><BR>ConnObj.Execute(SQLstatement)<BR> %&#062;<BR><BR>&#060;HTML&#062;<BR>&#060;head&#062 ;<BR>&#060;title&#062;&#060;/title&#062;<BR>&#060;/head&#062;<BR>&#060;body bgcolor="#CCCCCC"&#062;<BR><BR>Your Vistor Number is &#060;%=RstObj("no")%&#062;<BR><BR>&#060;/HTML&#062;<BR>&#060;%end if%&#062;<BR><BR><BR>&#060;%<BR>ConnObj.Close<BR>S et ConnObj = Nothing<BR><BR>RstObj.Close<BR>Set RstObj = Nothing<BR>%&#062;<BR><BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e07&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. <BR><BR>/asp/testit.asp, line 32 <BR><BR><BR>Just so you know, even though they&#039re giving me an error message, I really need the close tags in there. I get fined $500 by my provider for each unclosed database-accessing script that I use. I don&#039t know whether this might be causing the problem, if so, do you know any ways to work around it. I don&#039t want to be charged $500 due to my ignorance.<BR><BR>