ASP and Access

True/False db field causes 500 error

[chris_f]

Hi All,

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.

Thanks
Chris

[chris_f]

Please ignore. Fized.