How to list tables to open them

  • Thread starter Thread starter Wind54Surfer
  • Start date Start date
W

Wind54Surfer

Hi all,

I am wondering if there is a way to list all the tables so I can pick them
to view them.
I am not very good with code.

Any help really appreciated.
 
This query will list the table names for you:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE ((Not ((MSysObjects.Name) Like "MSys*" Or (MSysObjects.Name) Like
"~*")) AND ((MSysObjects.Type) In (1,4,6)))
ORDER BY MSysObjects.Name;

Alternatively, you can loop through the TableDefs collection.
 
Back
Top