Accessing the metadata files in Access

G

Gene53

In Sybase, I was able to get at the system tables (read-only) to extract
custom information about application tables and other objects in the
database. This was very useful because it even allowed us to create template
scripts that could generate (or regenerate) hundreds of standard Stored
Procedures.

I am trying to do much less with Access. I would just like an easy way to
quickly document (preferably something exportable to Excel) a cross reference
showing what objects use which tables and/or queries.

Would Microsoft ever consider making this available to a developer so we
could create our own custom documentation of the objects and the
relationships between them.

Currently I am trying to use the Analyser Tools/Documenter and this is not
only not working but If I remember using it in the past, it was not what I
needed when it did work.
 
G

Gene53

I missed an obvious solution that I found in hints provided in other
discussion points. I did an "Unhide" of the Access System tables, and as a
result, it looks like I should be able to extract the necessary information
out of these tables to create xrefs.
 
N

Nick Coe \(UK\)

In Gene53 typed:
In Sybase, I was able to get at the system tables
(read-only) to
extract custom information about application tables and
other objects
in the database. This was very useful because it even
allowed us to
create template scripts that could generate (or
regenerate) hundreds
of standard Stored Procedures.

I am trying to do much less with Access. I would just
like an easy
way to quickly document (preferably something exportable
to Excel) a
cross reference showing what objects use which tables
and/or queries.

Would Microsoft ever consider making this available to a
developer so
we could create our own custom documentation of the
objects and the
relationships between them.

Currently I am trying to use the Analyser Tools/Documenter
and this
is not only not working but If I remember using it in the
past, it
was not what I needed when it did work.
Click to expand...

MSysObjects is the table you want. You'll need to go into
options to make it visible. It contains info on forms and
so on, not easy to decode though.

Take a look at FMS analyzer
http://www.fmsinc.com/products/analyzer/index.html
 
Top