I need to access the following properties of an Access 97 table field by specifying the table name and field name:
- required
- data type
- field size
- default value
I can upsize to another version of Access if I have to, but I'd prefer not.
Is there a way to query the system tables to get these values? If so, can you provide the query? I have searched for hours and can't find this query or a good lead.
Thanks for the help.
- required
- data type
- field size
- default value
I can upsize to another version of Access if I have to, but I'd prefer not.
Is there a way to query the system tables to get these values? If so, can you provide the query? I have searched for hours and can't find this query or a good lead.
Thanks for the help.