>hi all,
>
>hoping someone might be able to help us solve an issue we are left scratching our heads at!
>after moving to an alternative webserver we are having the following error when updating an mdb:
>
>Microsoft JET Database Engine error '80040e10'
>
>No value given for one or more required parameters.
>
>/intcouriers/newsite/GlobalBookings/Confirmation.asp, line 221
>
>the code in question is:
>
> If (Not MM_abortEdit) Then
> ' execute the update
> Set MM_editCmd = Server.CreateObject("ADODB.Command")
> MM_editCmd.ActiveConnection = MM_editConnection
> MM_editCmd.CommandText = MM_UpdateQuery
> MM_editCmd.Execute
> MM_editCmd.ActiveConnection.Close
>
> End If
>
>can anyone see what we could be doing wrong?
>
>thanks

Whats in the strings MM_editConnection and MM_UpdateQuery