Forum Discussion
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.
Although I prefer to use VM's, the drawback to that approach is that you must install the Windows OS on them, and that means a license. If you have the budget for that, it's a great solution. The alternative, running your accdb with the /runtime switch doesn't require the additional Windows license.
I agree completely about using ACCDR files or the runtime switch instead of running two versions.
However, I deliberately didn't mention either of those as the OP stated he wanted to use MS 365 Access Runtime for testing as well as having Access 2019
However, I deliberately didn't mention either of those as the OP stated he wanted to use MS 365 Access Runtime for testing as well as having Access 2019
- Hi isladogs, arnel_gp, george hepworth,
Great info from all. I did open the db in runtime using the shortcuts. After doing so, I had questions which I posted on 6/24/22 as "Relationship flow chart not appearing." If you could look at that posting and reply I would much appreciate it. Additionally, I wanted to compare what I was experiencing with my db (the migration to SQL Express and also opening in Runtime) with doing the same procedures with Northwind db. So I opened my Access 2019 and opened a new Northwind db, and save the file. When I tried to open it in Runtime it would not allow me to do so. I WAS AMAZED THAT MS's OWN NORTHWIND COULD NOT OPEN IN RUNTIME. Could you also check that out? I'm asking for your help because of the great input you gave on this posting!Did the NW application simply fail to start in runtime? Or, was an error raised?
I ran the Northwind template as an accdr.
Yes, there is a macro action in the AutoExec macro that fails to run in the runtime. However, removing that one macro action is all it took to eliminate that problem
The macro action in question, SetDisplayedCategories, manipulates the Navigation Pane, which is not permitted in the run time environment, so it's not unexpected that it would fail.
- I can't find the other thread: Relationship flow chart not appearing.
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.
