Hi
I am trying to create a form page, much like on a forum where you type the content in a text area and then submit it and you can view the post straight away.
I am building the site in Dreamweaver with a MS Access table where the 'entries' are going into. I have matched all the data up however when I run the page locally, after clicking 'Submit' i get this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/spocking/post.asp, line 135
I have been to line 135, and it shows this:
If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
Line 135 is the bold one.
Any ideas?
Thanks
Tom


LinkBack URL
About LinkBacks
Reply With Quote