Looking for Tables in a Database

[GGerard]

Hello

How can I write code that would look through the current database and
generate a list of all
the tables and forms of the database (both opened and closed tables and
forms)

I am using MSACCESS 2000
Thanks
G.Gerard

[Allen Browne]

For tables:
SELECT MsysObjects.Nam e FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Nam e;
Include Type 6 for linked tables, and type 4 for ODBC linked tables.

For forms, use type -32768
Reports: -32764
Modules: -32761
Queries: 5

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"GGerard" <gg*****@nbnet. nb.ca> wrote in message
news:Ud******** *********@ursa-nb00s0.nbnet.nb .ca...

How can I write code that would look through the current database and
generate a list of all
the tables and forms of the database (both opened and closed tables and
forms)

I am using MSACCESS 2000