Relationship Layout

  • Thread starter Thread starter Stewart Berman
  • Start date Start date
S

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 said:
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
Click to expand...

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.
 
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.
 
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
 
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.
 
Back
Top