Add new column

J

JuliaC

Hi,

I would like to add a column in an existing table with this code.

ALTER TABLE tCheckImport ADD COLUMN bStdOpt BOOL

But it doesn' t work, what' s wrong with it ?

Regards
 
M

Michel Walsh

Hi,


Instead of BOOL, try one of these: BIT, BOOLEAN, LOGICAL, LOGICAL1, YESNO


Hoping it may help,
Vanderghast, Access MVP
 
Top