This has been annoying me for two days and I'm hoping someone can call me a dip and point out something obvious that is wrong. I am using ASP to update a TRUE/FALSE field in an access database.
Whenever the update is perfomed I get:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/ocbs/ocbs2/manager/manbookings.asp, line 153
The line of code is:
CancelBooking.Open "UPDATE Bookings SET CancelledBooking = 'TRUE' WHERE BookingID = " & Request.Form("bookingid")
If I update another field it works fine and I have verified the field name "CancelledBooking". It must be the TRUE bit, however, I have tried it as TRUE, 'TRUE' and "TRUE" to no avail.