rossmcl
Programmer
- Apr 18, 2000
- 128
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>