Relationship Layout

[Stewart Berman]

Access 2007

Where is the layout information for the Relationships window stored? Is it
in an object and if so how do I reference it?

Please note I am not talking about the relationships -- I know how to
extract that. I would like to know how to extract the current layout in the
Relationships window.

 

[Allen Browne]

It's stored in a table called MSysRelationships.

To see it, right-click the Nav Pane, and choose Navigation Options
Check the boxes for Hidden and System.

Stephen Lebans has a utility that interprets this table, though it's not
readable:
http://www.lebans.com/saverelationshipview.htm

If you just want to display more details about the fields on the
relationships report, see:
http://allenbrowne.com/AppRelReport.html

 

[Stewart Berman]

It's stored in a table called MSysRelationships.

To see it, right-click the Nav Pane, and choose Navigation Options
Check the boxes for Hidden and System.

Stephen Lebans has a utility that interprets this table, though it's not
readable:
http://www.lebans.com/saverelationshipview.htm

It is supposed to do what I want.

I converted it to an .accdb and tried to use it to read the relationship
layout in another .accdb and had a problem.

Is throwing an error when trying to open the MSysObjects table in an
external database -- no read access. Not sure why as the code to open the
recordset looks identical to the code I use to do the same thing. It should
not be hard to workaround.

 

[Allen Browne]

Sorry, I can't support you with Stephen's code, and he has moved on too. Not
sure what else to suggest.

I take it you're doing more than iterating the relationships themselves
(which you can do via the Relations collection in DAO), and you're trying to
ascertain which tables are displayed and where in the Relationships window.

 

[Charles Wang [MSFT]]

Hi Stewart,
To work around this issue, you can first import the hidden table
MSysRelationships from your external database to your local copy and then
read the local copy.

Best regards,
Charles Wang

 

[Stewart Berman]

Thanks but the problem was in reading the MSysObjects table. It should be
readable via an Database object. When I get some time I will investigate
further.