Combo Box not listing linked tables

  • Thread starter Thread starter Ernesto
  • Start date Start date
E

Ernesto

Hi all...question...

I have a combo box which I want to list all of my tables...I have the
following code for SQL...

SELECT msysobjects.Name
FROM msysobjects
WHERE (((msysobjects.Name) Not Like 'msys*') And
((msysobjects.Type)=1))
ORDER BY msysobjects.Name;

it works...but it isn't picking up my linked tables...how do I have it
pick up my linked tables?

thanks!
 
Type = 6 for "simple" linked tables, Type = 4 if they're linked using ODBC.
 
Back
Top