admin
41 TopicsMicrosoft 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"Solved411KViews8likes21CommentsMoving Away from MS Access
The organization I work for is wanting to move away from Microsoft Access databases where possible, and we have started exploring what tools our current Access databases could be moved to. Is there a standard for what works best (Powerapps, Sharepoint, etc)? What have you found to be a good resource for guidance on this topic? Thanks!121KViews2likes81CommentsMicrosoft Access System being discontinued?
Hello, I am looking for a way to create a database and all of my research is leading me to wanting to build a Microsoft Access based database. It seems as though this program would fulfill all my needs for my project, however, whenever I bring it up to colleagues, or search online for news, I keep seeing that the system is going to be discontinued and that I should avoid it, as I will soon have to find an alternative anyway. Can you confirm if this is true or not? I am having trouble finding a press-release, or news article from Microsoft directly about this topic. Thank you kindly.32KViews0likes15CommentsSteps To Decompile Your MS Access-Database
"Steps To Decompile Your MS Access-Database 1)On a Windows system go to Start and type ‘msaccess.exe /decompile ‘in the Run command line. Here msaccess.exe includes the complete path of the Access Database. 2)Now go to Access and open the database you want to decompile. 3)Open any module as per your requirement and compile it through Debug, Compile.., and then File, Save...." My question: It´s about ACCESS 2013. Everyone is mention the Debug in Tool menu. There is no Debug option under Tools in our MS Access 2013 Database: Please see screenshot (Swedish version) Here´s the english translate the sceenshot. -References -Macro -Properties for DB -Digtial sinature As you can see, no DEBUG in the below screenshot. Really appreciate your answerSolved23KViews0likes4CommentsAccess Prompts to enter password when trying to Compact/Repair DB
It's me again with another possible MS Access bug! This issue: MS Access asks for my database password when I go to compact/repair. I enter the password correctly and it doesn't take it.. What is going on!? Thanks, Justin2.8KViews0likes4CommentsODBC (Word Merge and Access DB)
1. I have been doing mail merges for decades using MS WOrd and MS Acces. 2. Currently using Office 365 products. 3. Last successful merge was at end of August 2020 4. No attempts to do merges until mid October 2020. 5. I receive what appears to be an ODBC setup manager window. 6. I do not recall ever having to work with this item. (see attached image) 7. At the bottom of the manager there is a test button. Clicking this results in an error message. (see attached image) 8. I have worked with MS support in both Windows and Office without success. The following has been tried: a) Office repair; b) uninstall and reinstall of Office; c) installation of Access redistributable2.3KViews1like5CommentsWorkday task
Request Id: 9b9fa281-6773-44e2-9202-799eb1225500 Correlation Id: 6b3fd261-26c7-4dfe-acb7-c5554bae3d4a Timestamp: 2022-01-20T17:25:28Z Message: AADSTS90072: User account 'Email address removed' from identity provider 'live.com' does not exist in tenant 'MAXIMUS' and cannot access the application 'http://www.workday.com'(Workday) in that tenant. The account needs to be added as an external user in the tenant first. Sign out and sign in again with a different Azure Active Directory user account Would anyone know how to help me with this?2KViews0likes2Comments