info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Show all the table names in the database through the code
0 views
Skip to first unread message
Tarun Jain
Apr 4, 2002, 4:02:51 PM4/4/02
to
Hi
I am trying to get the names of all the
tables,forms,query,reports in the database through the
code.
I am trying to get the names of all the
tables,forms,query,reports in the database through the
code.
Please help me piut
Thanks
-TJ
brent
Apr 4, 2002, 5:39:16 PM4/4/02
to
I'm not sure of how you can get it through the database
code, but you can go into Access under the Tools Menu,
Analyze, Documentor and get a report that you can print
out with all that information.
code, but you can go into Access under the Tools Menu,
Analyze, Documentor and get a report that you can print
out with all that information.
Brent
>.
>
Brendan Reynolds
Apr 5, 2002, 2:38:23 PM4/5/02
to
Which version of Access? In 2000 or later you can use the AllTables,
AllForms etc. collections, but there's no point in me providing an example
using those collections if you're using Access 97.
AllForms etc. collections, but there's no point in me providing an example
using those collections if you're using Access 97.
BTW, and just for future reference: If you want a code solution, this would
have been better in a different newsgroup. Unlike some other applications,
where 'macro' is a synonym for code, in Access code and macros are very
different animals.
--
Brendan Reynolds (MVP)
bren...@indigo.ie
Access 2000/2002 sample app at
http://brenreyn.brinkster.net
----------------------------
"Tarun Jain" <t...@aaronoil.com> wrote in message
news:125301c1dc1c$14e56ee0$3bef2ecf@TKMSFTNGXA10...
Steve Arndt
Apr 8, 2002, 2:44:54 PM4/8/02
to
Hi...
I reference a hidden table called MSysObjects in a query. The name field
will give a name for the objects. Type will give a type for the objects,
and flags appear to indicate if it's an MS provide object or a user created
object. To get the list of tables in my query, I set type criteria to 1 and
Flags to <> -214748346. This worked for me. Note: I had to set hidden and
system objects flags in the View tab to show the MS hidden tables to view
the contents of the table. If anyone knows why or why I shouldn't rely on
these fields or values in the MSysObjects table, I would appreciate knowing.
Steve
"Tarun Jain" <t...@aaronoil.com> wrote in message
news:125301c1dc1c$14e56ee0$3bef2ecf@TKMSFTNGXA10...
I reference a hidden table called MSysObjects in a query. The name field
will give a name for the objects. Type will give a type for the objects,
and flags appear to indicate if it's an MS provide object or a user created
object. To get the list of tables in my query, I set type criteria to 1 and
Flags to <> -214748346. This worked for me. Note: I had to set hidden and
system objects flags in the View tab to show the MS hidden tables to view
the contents of the table. If anyone knows why or why I shouldn't rely on
these fields or values in the MSysObjects table, I would appreciate knowing.
Steve
"Tarun Jain" <t...@aaronoil.com> wrote in message
news:125301c1dc1c$14e56ee0$3bef2ecf@TKMSFTNGXA10...
Brendan Reynolds
Apr 9, 2002, 6:02:51 AM4/9/02
to
The only potential problem that I know of is that the system tables are
undocumented, and working with them is unsupported, so there's no guarantee
that techniques that depend on the system tables will continue to work in
future versions of Access. I would imagine that it is probably unlikely that
those particular values will change, though.
undocumented, and working with them is unsupported, so there's no guarantee
that techniques that depend on the system tables will continue to work in
future versions of Access. I would imagine that it is probably unlikely that
those particular values will change, though.
--
Brendan Reynolds (MVP)
bren...@indigo.ie
Access 2000/2002 sample app at
http://brenreyn.brinkster.net
----------------------------
"Steve Arndt" <sar...@attbi.com> wrote in message
news:OXPb5zy3BHA.2592@tkmsftngp04...
0 new messages