ms-access update

<i><b>Originally posted by : techlink (samtan@yeah.net)</b></i><br />Dear all,<br /><br />I need your help on debugging:<br />I tried to update a record using aspx code. However, the server inform me "System.Data.OleDb.OleDbException: Syntax error in UPDATE statement". <br />1) I output the string of update statement and run the sql directly as a query on the server-side access file, it works.<br />2) The Web has the right to write to the database, I can delete a row using aspx.<br /><br />Can anybody help me figure out the problem?<br /><br />Thanks.<br />

<i><b>Originally posted by : Daniel (dancast@uol.com.br)</b></i><br />I don't have your answer but why do I get this:<br />"Operation must use an updateable query"<br />when I am trying to Add records to a Microsoft Access database using "INSERT INTO "?<br /><br />Please help me<br />Thanks<br />Daniel<br /><br /><br />------------<br />techlink at 5/16/2002 9:40:59 AM<br /><br />Dear all,<br /><br />I need your help on debugging:<br />I tried to update a record using aspx code. However, the server inform me "System.Data.OleDb.OleDbException: Syntax error in UPDATE statement". <br />1) I output the string of update statement and run the sql directly as a query on the server-side access file, it works.<br />2) The Web has the right to write to the database, I can delete a row using aspx.<br /><br />Can anybody help me figure out the problem?<br /><br />Thanks.<br />

<i><b>Originally posted by : Allan (allan@imswebwise.com)</b></i><br />The problem may be with security on the database file itself. If you go into the folder containing the file and right click, change the security settings so that internet/guest has full privilages.<br /><br />I got this to work but the problem I have now is that when and update runs, it updates every single record in the database. can any suggest anything?<br /><br /><br /><br />------------<br />Daniel at 6/6/2002 9:55:19 PM<br /><br />I don't have your answer but why do I get this:<br />"Operation must use an updateable query"<br />when I am trying to Add records to a Microsoft Access database using "INSERT INTO "?<br /><br />Please help me<br />Thanks<br />Daniel<br /><br /><br />------------<br />techlink at 5/16/2002 9:40:59 AM<br /><br />Dear all,<br /><br />I need your help on debugging:<br />I tried to update a record using aspx code. However, the server inform me "System.Data.OleDb.OleDbException: Syntax error in UPDATE statement". <br />1) I output the string of update statement and run the sql directly as a query on the server-side access file, it works.<br />2) The Web has the right to write to the database, I can delete a row using aspx.<br /><br />Can anybody help me figure out the problem?<br /><br />Thanks.<br />