SQL such as the following returns the Allows Null property of a column in SQL Server:
[code=sql]
select is_nullable from information_sch ema.columns where
table_name = 'TheTableName' and
column_name = 'TheColumnName'
[/code]
I need to do the same in MS Access and have tried the following:
[code=sql]
select ColumnProperty( Object_ID('TheT ableName'), 'TheColumnName' ,
'AllowsNull...