I get the following error every time I try to pass the<BR>parameters of an Access query to the Command Text String.<BR>I got the syntax from a book so it SHOULD be right!?<BR><BR>It works fine if I append the parameters individually<BR><BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR>[Microsoft][ODBC Microsoft Access 97 Driver]Syntax error or access violation (call) <BR> <BR> <BR>Name of Query is : Q_INSERTQUERY<BR><BR>Parameters FirstName Text, LastName Text, DOB DateTime; <BR>Insert Into TableA (NameFirst,NameLast, DateofBirth)<BR>Select [FirstName] as Expr1,[LastName] as Expr2, [DOB] as Expr3;<BR><BR>************ASP CODE****************<BR><BR>First= "John"<BR><BR>Last ="Doe"<BR><BR>DOFB = "07/01/99"<BR><BR>objCmd = Server.CreateObject("adodb.command")<BR><BR>objCmd .ActiveConnection = objConn<BR><BR>mySQL = "{Call Q_INSERTQUERY (&#039" & First &"&#039,&#039" & Last &"&#039,&#039" & DOFB & "&#039)}"<BR><BR>objCmd.CommandText = mySQL<BR><BR>objCmd.CommandType = adCmdStoredProc <BR><BR>objCmd.Execute<BR><BR>Any help will be greatly appreciated<BR><BR>Edward<BR>