create table SQL statement

[thomasp]

I am attempting to create a table in an Access database using VB2005 beta 2.
I seem to be able to get it to work all except for adding a Boolean column.
The following statement works if I remove the ""POI BOL, " & _" line from
it. Will someone please tell me the snytax for adding a boolean column?

Thanks,

Thomas


AccessCommand.CommandText = "CREATE TABLE NewUTAMS (" & _
"ID int identity, " & _
"DTG datetime, " & _
"Grid TEXT (10), " & _
"confGrid TEXT (10), " & _
"POI BOL, " & _
"confSource TEXT (50), " & _
"Weapon_Type TEXT (50), " & _
"Target_NO TEXT (4), " & _
"EastError INT, " & _
"NorthError INT, " & _
"CONSTRAINT PrimaryKey PRIMARY KEY (ID))"

 

[thomasp]

I found my answer. I should have waited a couple more minutes before
posting.

"POI BIT, " & _ works, now if I can figure out how to make it dispay as a
checkbox in access.

Thanks,

Thomas

 

[Cor Ligthert [MVP]]

Thomas,

Although you found your answer, do I suggest you to look at the parameters,
a more describting way to use when you are used to it.

http://www.vb-tips.com/default.aspx?ID=550279ec-6767-44ff-aaa3-eb8b44af0137

(We are maintanancing our website this week, so don't look at not yet
working new buttons etc this week).

I hope this helps,

Cor