Microsoft Office 2019 Now Available – Comparing 2019 vs 2016 vs 365, New Features in Access & Excel
Microsoft Office 2019 is out! Microsoft started the roll-out today of Microsoft Office 2019 for Windows & Mac – with major updates to Access, Excel, Word, PowerPoint, Outlook, Project, Visio, and Publisher – to commercial volume license customers. Microsoft is following up with Office 2019 releases to consumers and other business customers, as well as SharePoint / Exchange / Skype / Project Server 2019 releases, in the coming weeks. Office 2019 provides a subset of features Microsoft has added to Office 365 over the past three years. As Office 2019 is a one-time release, Office 365 is still the better choice with not only far more features (Co-Authoring, etc) unavailable in Office 2019, but also far earlier access to them than on-premises, non-subscription Office 2019, etc. editions. Speculation has been that Office 2019 may be the last perpetual license (on-premises / non-subscription) release of Office, so that Microsoft can focus in on its Office 365 subscription offerings. However, Microsoft has responded in one case that there is likely to be one more perpetual license release after this one. Either way, Microsoft Office 2019 product pages even describe Office 2019 as a "one-time release" with Office 365 being needed to gain access to new features after that. It may also be that there are fewer editions available for Office 2019 than for Office 2016. Whether you move to Office 2019 or 365, it's suggested you don't delay doing so, as Office 2016 cloud support will be dropped in 2020, with Office 2016 installs barred from connecting to Microsoft's cloud-based services, including hosted email (Exchange) and online storage (OneDrive for Business), after Oct. 13, 2020. New in Office 2019 Word– text-to-speech, improved inking & accessibility, focus mode, translator, Learning tools (captions & audio descriptions), @ Mentions PowerPoint – Morph transitions, Zoom, SVG, 3D model, play in-click sequence, 4k video, @ Mentions Excel – Power Query (Get & Transform) enhancements, Power Pivot included with all editions, new functions & connectors, publish to Power BI, AI-driven Excel Insights for chart suggestions, new charts, @ Mentions Excludes Co-Authoring, new Data Types like Stocks, and some other new features only available in Office 365 Outlook –@ Mentions, Office 365 Groups OneNote – OneNote for Windows 10 (Modern App included with Windows) has replaced OneNote desktop app (though OneNote 2016 will be available via Volume License Install tool) All Office apps – Ribbon customizations and roaming pencil case Microsoft Access - including the many updates we've seen recently such as: Modern Charts New Linked Table Manager Dark theme Big Int Salesforce & Dynamics connectors Other Recent Developments with Microsoft Access It's especially exciting to see all the new features, growing user base and communities, new integrations, and development team responsiveness seen with Microsoft Access of late. Inclusion on the Office templates page Which I hope will become permanent soon SQL Server Migration Assistant (SSMA) updates ODBC and OLE DB driver updates – for optimized use and new feature support for SQL Server, Azure SQL and other back-ends databases Power BI support (via On-Premises Data Gateway) Considering On-Premises Data Gateway is shared with PowerApps, hopefully that means we may see PowerApps support too in the future New & growing Access conferences and user communities: New Access Developers' Day in Amsterdam DevCon in Vienna, AEK in Germany, UKAUG in UK, PAUG in Portland, Access Day in Redmond, Access Madrid in Spain Presence at Microsoft Ignite and other conferences Access User Groups (AUG) webinars and local chapters (Chicago, Denver, Madrid, Hertfordshire, etc.) Access now included in most Office editions Included in nearly all (besides Online-only) editions Access in Office 365 Home, Personal, Business, Business Premium, ProPlus, E3, and E5 editions Access in Office 2016 Professional and ProPlus editions With MS Access having been added to most Office editions, presumably it will likewise be available with most Office 2019 editions now too. It's great to see these features available to Office 365 subscribers (or even sooner if opt-in for Insiders program) now being made available to others with Office 2019, and I look forward to the many more new advancements with Microsoft Access and Office to come. Links to More Info about Office 2019 You can find out more about Office 2019 with the following articles, FAQs and product pages: Office 365 vs. 2019 Editions Office 2019 Commercial FAQ Microsoft's Office 2019 Announcement Office 2019 and Discontinuing of Office 2016 The Verge release article ZDNet release article Endgadget release article VentureBeat release article TechSpot release article -- Dan Moorehead Founder & Chief Software Architect PowerAccess (www.PowerAccess.net) "Empower Microsoft Access – with new Tools | VBA Framework | PowerGit | Power Query-like PowerSQL | VSTO-like .NET API | CodeGen | Excel Formulas & Functions | Consulting | Excel ➜ Access ➜ SQL Conversion Tools"
Access Europe meeting on Wed 6 Sept - Database Analyzer and other tools
The next Access Europe meeting will be onWednesday 6 Sept 2023starting at18:00 UK time (6PM UTC+1)and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please checkhttps://www.worldtimebuddy.com/ In this month's session, I will be demonstrating my newDatabase Analyzer Proapplication. The free evaluation version is now available for download from the above link on my website If time permits, I will also be discussing a number of related Access examples and code samples such as: • the use of progress bars • creating a table of contents in Access reports • the undocumented SaveAsText/LoadFromText features • changing query views using command bars code For more details about this session, see:https://accessusergroups.org/europe/event/access-europe-2023-09-06/orhttps://isladogs.co.uk/aeu-19/ The meeting will again be held onZoom. When the time comes, you can connect using:Join Zoom Meeting. If you are asked, use:Meeting ID: 924 3129 5683 ; Passcode: 661210 For more connection options, please see theAccessUserGroups.orgweb page for this event All sessions are recorded and later uploaded to theAccess User Groupschannel onYouTube I hope you will join us for this month's session. As always, the session will be recorded and the video uploaded toYouTubeafter the event NOTE: I regret that the planned presentation on Better Access Charts by Thomas Moller originally scheduled for Wed 6 Sept has been postponed until further notice.
Access 2019 #Deleted Table status (Field NVARCHAR)
Hi, There has been an issue regarding Access 2019 displaying #Deleted status on certain table, for only certain windows user profile. Based on my analysis: 1. This happen to only certain user profile. If I login into the windows using another profile and open the table, the data will be normally displayed. 2. This table are linked table with SQL server 2016, so I have check and find that the table have NVARCHAR field. I try to change the field type to VARCHAR, refresh the table link, then the data can be viewed again. Current Solution: 1. Delete the user profile and login again. Solve the problems but not sure if it will happen again in the future. 2. Installing Access Runtime. Solve the problems but at the same time i can't debug the program if there something wrong with it. Does anyone have any idea what happen because i am really lost right now.Access Takes a Trip: News From Around the Globe
Check out our most recent blog post thatprovides a brief overview of some of the team's most recent user group sessions. We would like to have more of these in many more locations moving forward (both domestic and international), so if you have suggestions, please let me know! https://techcommunity.microsoft.com/t5/Access-Blog/Access-Takes-a-Trip-News-From-Around-the-Globe/ba-p/1015527
New modern style charts transformed row source problem
Hi, Have a Table1 (see an attachment) and a crosstab query on its base. Creating a form with a new style chart (I use Access 2019) with this very query as recordsource. No problem, everything works fine. Then I try to assign to the chart recordsource the same sql syntax as I have in my crosstab query but via VBA. And at this moment an error occurs with explanation that I have some mistake in FROM clause. But how can it be if I use the same syntax which I have in the query which works ok? As I understand the problem happens when Recordsource is being changed by Access in Transformed Recordsource. Please help! Thanks!Access 2007 to office 365/Access 2019 VERY SLOW
Hi there, First off I am not an Access guy at all. I have been asked to help figure out why an MS Access db that was tolerable in ms access 2007, speed wise, is now really slow in Access 2019 on MS Server 2016 Standard. We have upgraded to office 365 office 2019 and since doing so the performance has nosedived. There are 3 users working off a Windows 2016 Server Standard with remote desktop/terminal server. Everything else seems good to go but this database is driving the staff nuts. If they click a button it can take 60 + seconds to open the field/table. Any thought, suggestions or help is greatly appreciated :)
Keeping Access files on a SharePoint site??
Hello: I work as a research scientist and I keep a substantial amount of data in Access databases. I use both a virtual machine and a laptop to work with those databases. Using the VM is helpful because I can disconnect my laptop from my employer’s network without disrupting a long-running job. Because I use two machines I would like to keep them in one network location so that both machines are able to access (no pun) my databases. Keeping them in one spot will save me from wondering which file is the most current. I learned the hard way to never store Access databases in a location that synchronizes (such as Offline Files or OneDrive), because the database will be damaged if synchronization occurs while I have the file open. I have seen “hints” that it might be OK to store an Access database on a SharePoint site without the database becoming corrupt. Is this correct, and do I need to “check out” the database so that the other machine cannot open it? My network is slow, so I likely will have to download the Access file from SharePoint to work with it. Access Web Services are not available, and I do not want to use SharePoint lists because (as I understand it) SharePoint lists do not: support unique composite keys; the difficulty transferring Access tables to lists; the learning curve. Any suggestions or thoughts? Thanks in advance.
