Exclude tables in collection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to exclude hidden tables and system tables in a collection?
 
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*
~*
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box with table list 2
Excluding Alpha character in text field by filtering. 4
Create my own 'not in list' event ? 4
My query does not yeild the results desired. 2
query excluding listings from table 2
Average Question 2
Access Remove rows based on multiple fields 2
How to ignore a column of numbers in Grand Total for rows 1

Back
Top