I know now to use the sql create table statement, but I use it on Access. The default property for the fields is not to allow null values. Is it possible to set the property Allow Zero Lenght to true in Access from VB?

Is there any other way (ADO?) to create tables in an Access database?

Rick