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.
 

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

Dynamic Table Linking 1
Update a combobox on another form 1
Need combo box to refresh when moving to new record 2017 1
LINK COMBO BOX WITH TABLE 1
Filling More than one field a combobox selection 2
textbox and combobox 3
Lookup current record with ComboBox, any changes create new record 3
Combobox to listbox data help 2

Back
Top