I'm using an SQL statement to try and run an Update statement to an Access database. Unfortunately I have to mess with a YES/NO field aka boolean. Here's my current statement:

UPDATE [table1] SET field1 = 'blah',field2 = 'blahblah',TorF = no WHERE num = 289

now I've tried yes, no, 0, 1, True, and False and every one of them result in a "data mismatch type." Now I looked this up extensively online and some sources say 0 and 1 should work and others say True and False out of single quotes should work. So is there some sort of VB data adapter or other ADO problem going on here that's interfering with it? I thought the data adapter will send anything even if I sent it an SQL string of "hey go do some databasey stuff, alright?" and let the DB handle it but then again it it specifically an OLEDB adapter. So yeah I'm sure someone here has at some point had to deal with the yes/no field so what worked for you?