A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Relationship Layout



 
 
Thread Tools Display Modes
  #1  
Old February 11th, 2010, 06:41 AM posted to microsoft.public.access.tablesdbdesign
Stewart Berman
external usenet poster
 
Posts: 68
Default 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  
Old February 11th, 2010, 09:37 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default 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  
Old February 11th, 2010, 04:21 PM posted to microsoft.public.access.tablesdbdesign
Stewart Berman
external usenet poster
 
Posts: 68
Default 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  
Old February 12th, 2010, 01:31 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default 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  
Old February 12th, 2010, 06:35 AM posted to microsoft.public.access.tablesdbdesign
Charles Wang [MSFT]
external usenet poster
 
Posts: 68
Default 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  
Old February 12th, 2010, 11:27 PM posted to microsoft.public.access.tablesdbdesign
Stewart Berman
external usenet poster
 
Posts: 68
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:40 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.