Cannot Insert Record to Database

<i><b>Originally posted by : Jeff (jefflee1@hotmail.com)</b></i><br />Hi there,<br /><br />I am new to ASP. I greatly appreciate if somebody can help me! <br /><br />I create a SIGN IN page for customer to sign in, but I always got the error code :<br /><br />~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`<br />Error Type:<br />Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<br />[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.<br />~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`<br /><br />I wrote the code exactly same as WROX's book. I really don't know what's wrong with the code. Please kindly help me solve this problem. Thanks!<br /><br /><br /><br />Regards,<br />Jeffrey<br />

<i><b>Originally posted by : Shawn McFarland (shawn.McFarland@seg-outdoor.com)</b></i><br />The Query that you are trying to update through in access is the problem. If the query is not updateable then the asp code will not be. <br /><br />Usually if the query is not updateable then it is due to not having the tables in the query related by the primary key of each table.<br /><br /><br />------------<br />Jeff at 12/7/2000 8:02:35 PM<br /><br />Hi there,<br /><br />I am new to ASP. I greatly appreciate if somebody can help me! <br /><br />I create a SIGN IN page for customer to sign in, but I always got the error code :<br /><br />~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`<br />Error Type:<br />Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<br />[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.<br />~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`<br /><br />I wrote the code exactly same as WROX's book. I really don't know what's wrong with the code. Please kindly help me solve this problem. Thanks!<br /><br /><br /><br />Regards,<br />Jeffrey<br />