Building an Insert String - Operation must use updateable query.

<i><b>Originally posted by : Ross McLanachan (rmclanac@lehman.com)</b></i><br />Hi there<br />I am using the below to write to a guestbook table in Access2000.<br />########################<br />'Build Insert String<br />strSQL = "INSERT INTO Guestbook(Name, Email, Date_Entered, URL, IP_Address, Message)"<br />strSQL = strSQL & " SELECT "<br />strSQL = strSQL & "'" & Name & "' as text1, " <br />strSQL = strSQL & "'" & Email & "' as text2, "<br />strSQL = strSQL & "'" & Date() & "' as text3, "<br />strSql = strSQL & "'" & URL & "' as text4, "<br />strSql = strsql & "'" & IPAddy & "' as text5, "<br />strSQL = strSQL & "'" & replace(request("Message"), "'", "''") & "' as text6 " <br />conn.execute(strSQL)<br />conn.close<br />set conn = nothing<br />#################<br /><br />It gives me the following error:<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. <br /><br />/cgi-bin/test/rmclanac/savemessage.asp, line 34 <br /><br /><br />=======<br />Can you please help me? Does anyone know how to get around this problem?<br />Any help would be much appreciated.<br />Thanks In Advance<br />Ross McLanachan<br /><br /><br /><br />

<i><b>Originally posted by : steve</b></i><br />http://aspfree.com/asp/startpage.asp?id=98<br /><br /><br /><br />------------<br />Ross McLanachan at 5/12/2000 7:01:35 AM<br /><br />Hi there<br />I am using the below to write to a guestbook table in Access2000.<br />########################<br />'Build Insert String<br />strSQL = "INSERT INTO Guestbook(Name, Email, Date_Entered, URL, IP_Address, Message)"<br />strSQL = strSQL & " SELECT "<br />strSQL = strSQL & "'" & Name & "' as text1, " <br />strSQL = strSQL & "'" & Email & "' as text2, "<br />strSQL = strSQL & "'" & Date() & "' as text3, "<br />strSql = strSQL & "'" & URL & "' as text4, "<br />strSql = strsql & "'" & IPAddy & "' as text5, "<br />strSQL = strSQL & "'" & replace(request("Message"), "'", "''") & "' as text6 " <br />conn.execute(strSQL)<br />conn.close<br />set conn = nothing<br />#################<br /><br />It gives me the following error:<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. <br /><br />/cgi-bin/test/rmclanac/savemessage.asp, line 34 <br /><br /><br />=======<br />Can you please help me? Does anyone know how to get around this problem?<br />Any help would be much appreciated.<br />Thanks In Advance<br />Ross McLanachan<br /><br /><br /><br />