I have tried to update access database from user form. I have checked that my connection/recordset are valid. I can response.write that my request.form(txtboxes) are good. But the minute the code hits --Recordset.Update I get the following error:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e21&#039 <BR><BR>[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO statement<BR><BR>My SQL Statment is SELECT * FROM TableName I&#039m not even using the INSERT INTO Statement !!!!<BR><BR>I have tried using Insert but have too many fields to put all in one statement. <BR><BR>Any ideas?