SQL query to change Required property MS Access

[AvatarZA]

I require a SQL statement that changes the Required property on a field in a MS Access database.

Any help would be great.

Thanks in advance

 

[PHV]

Take a look at the Required property of the DAO.Field object you can retrieve via the CurrentDB.TableDefs collection.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[AvatarZA]

I am not too sure on how to go about getting these objects and collections, I am actually using VB.Net and all I can use is a SQL statement to alter the property(that I know of).

Thanks for the help PHV but I need that in a query?