I have an Asp application that displays basic info about a chosen database (Table names, types and descriptions) and basic info about the fields in a chosen table (Field name, type, size, format and description)
I get the field Formats (i.e. "mm/dd/yyyy" for date types) from the Object Definition table produced by the Access Documenter wizard (have to make sure the table is produced and exists).
I would much rather retrieve this information from a schema. However, the format information doesn't seem to exist in any of the available schemas (adSchemaColumns, for example).
Where does the Documenter wizard get this info? Is there, in fact, a schema from which I can retrieve this info?
I get the field Formats (i.e. "mm/dd/yyyy" for date types) from the Object Definition table produced by the Access Documenter wizard (have to make sure the table is produced and exists).
I would much rather retrieve this information from a schema. However, the format information doesn't seem to exist in any of the available schemas (adSchemaColumns, for example).
Where does the Documenter wizard get this info? Is there, in fact, a schema from which I can retrieve this info?