MSysDB (Access 2000)

C

Colin Gordon

Part 1:
This is not a corrupted DB question! I would like to know what this object
is and, if it's a table, what it contains. Is it a table? If it is a table,
why does it not show when you set view options to show system and hidden
objects? If it is a table, why does running a query to select * from it shut
down Access?

Part 2:
What I want to achieve is to be able to list table, query and report objects
in a database. I can do this simply using MSysObjects and name/type columns
(table=1, query=5, report=-32764). But I want more: I want to be able to say
that REPORT1 is based on QUERY1 which uses TABLE1 and TABLE2. So I need to
find information in system tables that links TABLE1 and TABLE2 to QUERY1,
and information that links QUERY1 to REPORT1. Can this be done? Thanks for
any help offered.
 
D

Douglas J Steele

The answer to part 2 is no. The details for which you're looking aren't
stored in any of the system tables.
 
C

Colin Gordon

Thanks Doug, that at least kills this avenue of investigation. So... part 2
continued... is this information held anywhere within Access? I'm not an
Access expert, nor VB, but can achieve most things I want to if I know where
to begin. Again thanks for all help offered.
 
G

Guest

To see how a Report is stored in Access, use

application.saveastext acreport,"report1","c:\tmp.txt"

Originally, each report was tokenised and stored in
something like a binary memo field in one of the system
tables - but apparently MS had trouble maintaining
referential integrity in the project records, so now the
whole project is stored in just one blob.

Although you can export this and parse the text, it is
more common to open the report (in either preview
mode or design mode) and use the report properties.

docmd.Openreport "report1",acViewDesign
msgbox reports("report1").Recordsource

You can build code to trace the dependencies and
put them into a table, or you can buy a third-party
tool which does that, or Access 2003 has improved
dependency reporting (but I've never looked at that).

(david)
 
C

Colin Gordon

Thanks David. I'll look into this SaveAsText method as I wasn't aware of it
before. Regards.
 
Top