Access Linked Table Confirmation

[ChrisNorris]

I am listing all the tables in a selected Access database using VB.

When I add these tables to a list box I need to know if the table is a linked table or stored in the selected database.

I use the Containers object to loop through the tables but cannot find a command to check if the table is linked or not.

Any help would be apreciated

 

[Aivars]

Hi!

You can open this query:

SELECT MSysObjects.Name AS [Table Name], IIf([Type]=1,'Stored ','Linked') AS [Table Type]
FROM MSysObjects
WHERE MSysObjects.Name Not Like 'MSys*' AND (MSysObjects.Type=1 Or MSysObjects.Type=6);

Table MSysObjects is Access system table. You can descry it after checking <DB Menu bar>;<Tools>;<View>;<System objects> = True

Aivars

 

[ChrisNorris]

That is just fantastic.

I thank you very much

Chris