Combo Box not listing linked tables

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!
 
D

Douglas J Steele

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

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

Combine multiple tables into one 8
Listbox selection to execute a query 2
The purpose of these query 2
Forms in Combo Box 3
System Selected Table for Query/Report 3
All forms in a Combo Box 3
Fill a Combo Box with Table Names 3
Table Documentation 1

Top