required fields in access

[p_nivalis]

Hello, I followed this tutorial to programatically create an access database: http://www.codeguru.com/vb/gen/vb_database/microsoftaccess/article.php/c5149/ Everything works, but the database that it creates contains required fields, so when I try to update the database with a few null values it has a fit. Is there a way to set certain fields so that they aren't required?

 

[cjard]

If youre defining your schema with Jet DDL, then you can leave off the NOT NULL check of a particular field when creating the table..