ComboBox and Linked Tables

  • Thread starter Thread starter David Mulholland
  • Start date Start date
D

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?
 
Set its RowSource to

SELECT Name FROM MSysObjects WHERE Type = 4 ORDER BY Name
 
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.
 
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.
 
Back
Top