Forum Discussion
Solved
How do I uninstall Access 2019 in order to try MS 365 Access Runtime?
I have Access as part of my MS Office Pro 2019 package. I want to test MS 365 Access Runtime using a Access program that I wrote. I have not installed the MS 365 Access Runtime software yet, becaus...
- If you have Windows 10 Pro, you have Hyper-V which you can use for the purpose.
However, I prefer Virtual Box which you can download for free from Oracle and is actively being developed / updated on a regular basis. Very simple to setup and use.
I can't find the other thread: Relationship flow chart not appearing.
Please can you provide a link
Please can you provide a link
https://techcommunity.microsoft.com/t5/sql-server/relationship-flow-chart-not-appearing/m-p/3549372
Here is the posting:
Relationship flow chart not appearing
When I used Access as the back end for my database, I would click onto Database Tools then Relationships and would get a flow chart of all the my tables and all the relationships: ie one-to-many, etc.. The Database Documenter would also list the relationships.
Now that I use SQL Express Server as the back end for my database, when I open Access and click onto Database Tools then Relationships my tables appear without the relationship flow chart. The Database Documenter does not list any relationships.
Am I doing something wrong.
I thought that the relationships were transferred with the tables to the SQL Server.
Here is the posting:
Relationship flow chart not appearing
When I used Access as the back end for my database, I would click onto Database Tools then Relationships and would get a flow chart of all the my tables and all the relationships: ie one-to-many, etc.. The Database Documenter would also list the relationships.
Now that I use SQL Express Server as the back end for my database, when I open Access and click onto Database Tools then Relationships my tables appear without the relationship flow chart. The Database Documenter does not list any relationships.
Am I doing something wrong.
I thought that the relationships were transferred with the tables to the SQL Server.
Ah, what you refer to as the "Relationship flow chart" is better known as the "Relationship Window" in Access and as the "Relationship Diagram" in SQL Server, so that part is cleared up.
True, relationships should be transferred when migrating tables from Access to SQL Server, and, if you open SSMS and select "Relationship Diagram" you can see and modify relationships. Note that there can be multiple versions for a database, should it happen to have a large number of tables.
In the Access Relationship Window, you can DISPLAY relationship information, but it can ONLY be modified in the SQL Server, so the Access Relationship Window should be considered a convenience, not a tool. Note, for example, that join lines do not designate Primary and Foreign Keys here; any lines drawn between fields are strictly visual aids. Moreover, by default, tables won't be displayed, so you do have to add them to the relationship window.
Great info again! Access certainly is an amazing UI. I am incorporating SQL in order to give multiple users of my db access via cell phones. I would not do it if the Access data was reachable similar to the SQL data.
