ComboBox and Linked Tables

[David Mulholland]

Not sure where the best place for this topic but here it goes..

How can I have a combobox populate itself with a list of all the linked
tables in the DB? Specifically tables that are linked to other MDBs. I have
ODBC connections to an Oracle box that I don't need to worry about.

Any ideas?

 

[Douglas J. Steele]

Set its RowSource to

SELECT Name FROM MSysObjects WHERE Type = 4 ORDER BY Name

 

[David Mulholland]

Thanks for the response Doug. The Type 4 gave me the ODBC connections instead
of the regular mdb linked tables I was looking for. But after seeing what you
did and a little Google-Fu, I came up with the type 6 for attached tables.
Appreciate the help.

 

[Douglas J. Steele]

Sorry: I misread your post. You did specifically say you wanted linked to
other MDBs, and not the Oracle tables, but I only saw "ODBC connections to
an Oracle box" when I read it. Glad you got it figured out.