I want to input records into an Access database using a form. Part of my code is:<BR><BR>set objConn = server.createobject("ADODB.Connection")<BR>objConn .Open strProvider<BR>set cm = Server.CreateObject("ADODB.Command")<BR>cm.ActiveC onnection = objConn<BR><BR>cm.CommandText = "INSERT INTO ... VALUES(?,?,...)"<BR><BR>set objparam=cm.createparameter(, 200, , 255, textbx1)<BR>cm.parameters.append objparam<BR><BR>Can anyone please tell me what values I have to use in the createparameter if the value "textbx1" goes into a field in a table of datatype<BR><BR>1. Date/Time<BR>2. Number<BR>3.Primary Key of type Text.<BR><BR>As on using the above setting for datatypes other than text I am getting an error<BR><BR>Microsoft JET Database Engine error &#039;80040e07&#039; <BR><BR>Data type mismatch in criteria expression. <BR><BR>Thanks!<BR>