Windows 10: MS Access 2016 Saving Relationships

Carlos Ganus · May 14, 2019

MS Access 2016...…...I am confused regarding the saving of relationships. I spend a lot of time defining new relationships which seems to disappear when a new one is defined and saved. My database involves several tables that must be related and have different relationships. My question is how do I save a relationship that is only deleted when I wish. That probably means that each query, form and report must be able to save the related relationship and be recallable when the object is executed. Perhaps this is already a part of the Access 2016 design and I haven't read or otherwise become knowledge of the feature. Can some one offer guidance on this issue. Thanks! Carl

:)

meebers · May 14, 2019

Word 2016 crashes on save/save as

When I do a save as or save, MS Word 2016, Version 1704 Build 8067.2157 becomes non responsive. No matter what the destination is, usually documents, it just crashes. Task manager to get out of it. Searched for problem on the internet, tried most if not all of the suggestions same result. Tried the Office repair, same problem. Appreciate any suggestions.

UPDATE: Now all programs in office have the same "save to" crash.*Sleepy

Brink · May 14, 2019

New feature updates for Power Pivot in Excel 2016

We are pleased to announce new feature updates to Power Pivot for Excel 2016 as part of your Office 365 subscription. These updates include the ability to save a relationship diagram view as a picture and enhancements to the relationship dialog experience. We also fixed a number of important bugs to improve your overall modeling user experience.

Save relationship diagram view as picture

Excel 2016 users can now save the data model diagram view as a high resolution image file that can then be used for sharing, printing or analyzing the data model. To create the image file, in the Power Pivot add-in, click File and then select Save View as Picture.

Enhanced Edit Relationship dialog creates faster and more accurate data relationships

Excel 2016 Power Pivot users can now manually add or edit a table relationship while exploring a sample of the data—up to five rows of data in a selected table. This helps create faster and more accurate relationships without the need to go back and forth to the data view every time you wish to create or edit a table relationship.

We have also added several usability goodies to the Edit Relationship dialog:

Table selection using keyboard navigation—Type the first letter of a table name to move the first column name starting with the selected letter.

Column selection using column navigation—Type the first letter of a column name to move the first column starting with the selected letter. Retype the same letter moves to the next column starting with the selected letter.

Auto column suggestion for same column name in both tables—After selecting the first table and column, on the selection of the second table, if a column with the same name exists, it is auto-selected (works both ways).

Fixes that improve your overall modeling user experience

We made a few fixes that improve your modeling user experience, including:

Power Pivot data model is no longer lost when working with hidden workbooks.

Ability to upgrade an Excel 2010 workbook with a data model to Excel 2016 is now available.

Ability to add a calculated column in Power Pivot, unless it contains a formula, is now available.

For a full list in this customer update, visit Power Pivot and the Analysis Services Engine in Excel 2016 fixes.

For all Excel 2016 users, get the latest customer update by installing the following updates. Note, there are 32- and 64-bit versions of each, so be sure to download the right version:

KB3114374—Office 2016 Excel update from December 8, 2015.

KB3114297—Office 2016 Power Pivot in Excel from December 8, 2015.

Try them yourself!

Try these new improvements and see how they can help you improve your analysis performance. Do you have ideas on other improvements that you’d like to see in Excel? Visit the Excel UserVoice and tell us about them.
Click to expand...

Source: New feature updates for Power Pivot in Excel 2016 - Office Blogs

Vinodh_Kumar V · May 14, 2019

to add "ms access" in open with list when I right click on an

Hi Moideen,

Welcome to Microsoft Community.

I understand that you are willing to add MS Access in 'Open with' menu in Windows 10. I will certainly help you.

I suggest you to follow the below steps and check if it resolves the issue.

1. Right click on .mdb file, select
Open with click on Choose another app.

2. Look for MS Access from the list, if found, select it and click on
OK.

3. If not, navigate to More apps > Look for another app on This PC
and select the MS Access from the list.

4. Then on you can find MS Access default, on Open with
list.

Hope this helps. If the issue remains unresolved, please get back to us and we would be happy to help.

Windows 10: MS Access 2016 Saving Relationships

MS Access 2016 Saving Relationships

MS Access 2016 Saving Relationships

MS Access 2016 Saving Relationships

MS Access 2016 Saving Relationships - Similar Threads - Access 2016 Saving

what is relationship of MS PIN to account and/or device

what is relationship of MS PIN to account and/or device

what is relationship of MS PIN to account and/or device

MS Access 2016 annoying problem!!

MS Office 2016

MS Access 2016 Saving Relational table designs.

MS excel 2016 issue

MS Office 2016 word documents when saved look differently

Word 2016 crashes on save/save as