I am using Access 2000. In the SQL statement "Create Table..." how can you specify that you are allowing null values for a specific field. NULL won't work. AllowZeroLength won't work.
I'm not 100% sure but I think NULL is default, if you want to disallow NULL's you have to specify NOT NULL, otherwise do nothing!