Dear VB programmers,

Last question was wrong!!

I want to create i a Access database a table with a boolean field.

Set Ws = DBEngine.Workspaces(0)
Set Db = Ws.CreateDatabase("c:\new.mdb", dbLangGeneral)
Db.Execute "Create Table NewTable ( NewField Text);"

The field NewField will now be the data type text.
What do I have to fill in to get the field NewField boolean?

Nice regards,

michelle.