If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relationship Layout
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. |
#2
|
|||
|
|||
Relationship Layout
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 -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Stewart Berman" wrote in message ... 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. |
#3
|
|||
|
|||
Relationship Layout
"Allen Browne" wrote:
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. If you just want to display more details about the fields on the relationships report, see: http://allenbrowne.com/AppRelReport.html |
#4
|
|||
|
|||
Relationship Layout
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. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Stewart Berman" wrote in message ... "Allen Browne" wrote: 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. If you just want to display more details about the fields on the relationships report, see: http://allenbrowne.com/AppRelReport.html |
#5
|
|||
|
|||
Relationship Layout
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 |
#6
|
|||
|
|||
Relationship Layout
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. ("Charles Wang [MSFT]") wrote: 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 |
Thread Tools | |
Display Modes | |
|
|