(SQL) create table statement

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

It is very possible to manipulate almost any aspect of an Access Database with Ado. You must use the ADOX API. For information on capabilities and use of the API, I suggest you either go to the msdn developer library, or look for a book on database programming for visual basic

Cheers