Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ultra Dev ASP error

Status
Not open for further replies.

apowell

Programmer
Jan 5, 2001
2
US
I've created an ASP form in Ultra Dev and I have a good DSN-less connection to a remote Access DB, however, when I press submit on the form I get a line 91 error shown below:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'MM_editCmd.Update'

/infoform.asp, line 91


Code Snippet:
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.Update
MM_editCmd.ActiveConnection.Close

If (MM_editRedirectUrl <> &quot;&quot;) Then
Response.Redirect(MM_editRedirectUrl)
End If
End If
 
.update is not a valid method of an ADO Command object.

Perhaps you are looking for .execute

:)
Paul Prewett
penny.gif
penny.gif
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top