Add new column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi,


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


Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Access Access VBA question 0
Checking if data exists another table and, if yes, extracting a value 0
SQL Change Column name 5
Excel VBA - counting cells by colors and names to it in two different rows. 0
Multiple ADD COLUMN in one shot? 2
alter table and order by 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top