Trouble adding Access boolean column

[bonedoc]

I am trying to add a boolean column to my access table, but this does not work:

ALTER mytable ADD COLUMN myColumn BOOLEAN

any ideas why this does not work?

I have used

ALTER mytable ADD COLUMN myColumn BIT

and

ALTER mytable ADD COLUMN myColumn YESNO


...They work, but they do not produce a checkbox value in access, just 1 and 0. Anyone know how to create a checkbox data field?

 

[jmcilhinney]

It's quite possible that it's not possible. You're probably creating the correct type of column with the last piece of code but the check box is a function of how the Access application displays the data, not how it's stored. I would guess that you'd have to use ADOX, which you can read about on MSDN. I could be wrong about that, but I'm thinking that that's the case.