yes/no fields not working in sql
Posted on 2007-08-06
I had an access database which I have had to move to sql. I am accessing it through an access front end -( .mdb not adp) with an odbc connection. I had alot of fields in my access database which were yes/no fields and my forms had check boxes for them. Since moving my database to sql the values are still there, ex: the yes shows up as -1 and nos show as 0. They are bit datatypes in the sql database and yet still show as yes/no fields inn the access front end. However, my check boxes don't work anymore. Here is the criteria that I had on each check box (with different field names.)
They worked great before. How can I get them working now that my db is in sql?