Accessing table metadata

[JoeSmoe55]

Hello all,

happy new year!! I am wanting to programatically access table and column metadata ( i.e. data type, length (if integer), is it a primary key, such and so forth...). Is it possible? My assumption is that it is but I don't know what keywords to use in help. Metadata doesn't work. thanks.

Joe

 

[Remou]

I think the word you want is TableDef.

 

[JoeSmoe55]

yep I found out how to do it already by looking in the good 'ol object browser. Sorry I must not have looked too hard. Thanks Remou.

For those interested - here's a simple example.

Dim td As TableDef, f As Field

For Each td In CurrentDb.TableDefs
With td
For Each f In .Fields
MsgBox .Name & "." & f.Name & " is a " & IIf(f.Type = dbText, "String", "Not a String")
Next f
End With
Next td