By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,807 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,807 IT Pros & Developers. It's quick & easy.

Looking for Tables in a Database

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
For tables:
SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Name;
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.