Getting a list of tables thru SQL

[jdebeer]

On Dev Ashish's site there is a code snippet to get a list of tables
but this ode only shows the actual tables in the mdb. What is the
code to also show the linked tables.

Thanks

jdb



SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND
((MsysObjects.Type)=1))
ORDER BY MsysObjects.Name;

 

[Marshall Barton]

On Dev Ashish's site there is a code snippet to get a list of tables
but this ode only shows the actual tables in the mdb. What is the
code to also show the linked tables.

SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND
((MsysObjects.Type)=1))
ORDER BY MsysObjects.Name;

SELECT MsysObjects.Name
FROM MsysObjects
WHEREMsysObjects.Type=6
ORDER BY MsysObjects.Name;

 

[John de Beer]

Thanks very much

On Dev Ashish's site there is a code snippet to get a list of tables
but this ode only shows the actual tables in the mdb. What is the
code to also show the linked tables.

SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND
((MsysObjects.Type)=1))
ORDER BY MsysObjects.Name;

SELECT MsysObjects.Name
FROM MsysObjects
WHEREMsysObjects.Type=6
ORDER BY MsysObjects.Name;