Exclude tables in collection

C

Carol Giannini

Is it possible to exclude hidden tables and system tables in a collection?
 
A

Allen Browne

Sure.

When you loop through the TableDefs to load your collection, examine the
Attributes of the TableDef, e.g.:
If (tdf.Attributes And dbSystemObject) = 0 Then
'include this one
End If

You could also skip them by name.
Typically, exclude any like:
MSys*
USys*
~*
 
Top