[AccessD] accessing metadata

Susan Harkins harkins at iglou.com
Sun Feb 23 20:21:00 CST 2003


Trying to return meta data -- specifically, the Description setting of any
given field in a table. It should be easier than I'm making it -- started
here:

Dim rst As ADODB.Recordset
  Dim fld As ADODB.Field
  Set rst = CurrentProject.Connection.OpenSchema(adSchemaColumns)
  Do Until rst.EOF
    For Each fld In rst.Fields
        If Not IsNull(fld.Value) Then
            Debug.Print fld.Value & vbTab
        End If
    Next fld
  Loop

I should be able to limit the tables using criteria in the OpenSchema
method, but I haven't gotten it right yet. If there's an easier way to
approach this problem, would like to hear it.

Thanks!
Susan H.




More information about the AccessD mailing list