help plz [modified]

[Devkranth Kishore Vanja]

i have an column check in access database which is of datatype yes/no i need to update the state ie.. uncheck the query below does not work it says error in update statment update tbladvance set check=false where ecode='1011' and type='festival' and check=true the above query executed in Ms-Access query works perfectly but not through the code help me :( -- modified at 4:47 Thursday 28th June, 2007

[ZeedijkMike]

Without being an Access expert I do see something that looks a little odd in the code you posted. update tbladvance set check = false and where ecode = '1011' and type = 'festival' and check = true Should probably be: update tbladvance set check = false where ecode = '1011' and type = 'festival' and check = true So remove the 1st AND Regards,

Mike

[Devkranth Kishore Vanja]

hi mike sorry!.. And is not there... query written by u is the same query i execute.. but it doesnt exectute at all

[mohantfor net]

update tbladvance set check=false where ecode='1011' and type='festival' and check=true