I&#039m trying to use the OpenSchema method of the connection object to get information on field properties for error checking purposes. I&#039m working with a Microsoft Access database. I used the code listed on 4Guys at http://www.4guysfromrolla.com/webtech/101799-1.shtml<BR>and it worked fine for listing the names and types of the fields in each table, but the Allow Nulls and Default Value did not display correctly. Does anybody have an idea as to why this is happening. Also, does anyone know an alternate way of getting the Allow Nulls and Default Value besides going through the OpenSchema method? <BR><BR>Thanks