Using Microsoft Access with Power BI We recently had a client who wanted to view his QuickBooks data in Power BI, but the former could not connect with the latter to get the data, so we resorted to exporting the data from Quickbooks, using Access to clean it up and finally upload it to PowerBI.com s [...]
Microsoft Access is NOT Dead and Neither is VBA Catch my latest podcast on why Access is not dead! Episode 1: Introduction to the podcast Episode 2: More great examples of why Microsoft Access rocks for business Episode 3: Why Microsoft Access is NOT going away Episode 4: Best practices for Microsof [...]
Netherlands Access Developer Day 2019 – 14 September Access developer day is quickly approaching and you still have time to register and get a discount. It promises to be a great experience with the Access team and some of the brightest Access developers in the world. To register and learn more deta [...]
Catch my 'Optimizing Microsoft Access with SQL Server' Presentation Next week August 12, 13 and 14th I will be doing a different SQL Server PASS group each night in Iowa, it’s the perfect opportunity for you to catch my “Optimizing Access with SQL Server” presentation if you live nearby live and in [...]
Gotchas When Using Microsoft Access Runtime We've noticed more firms migrating over to Office365 and it's liberal policies of 5 licenses per user, but there are still instances were providing an office license is too expensive for a mission critical application, prompting many to use the Access runt [...]
NOTE: I will be talking about this topic in depth in the upcoming Access and SQL Server monthly webinar on July 9th at 6:30 PM CDT. Register so that you can view the process live and ask questions! As we work with several applications and sometime in a team, source code control is pretty impo [...]
Optimizing Microsoft Access with SQL Server IndyPass - 5/21/19 Join me on Tuesday May 21st 2019 as I present Optimizing Access with SQL Server to the great folks at IndyPass. I’ll be discussing all the great tips and techniques we use with clients around the world. Pizza will be served as well. Abst [...]
Join Me on Tuesday April 9th for the latest Microsoft Access News Fresh off my MVP Summit last week I’ll be discussing the latest on Microsoft Access. I’ll also be talking about the challenges of taking a product built on Access to the market. Join us! Tuesday April 9th at 630 PM CST (-5 UTC) https: [...]
Listen to Episode 2 of the Microsoft Access Podcast This episode I’ve got more great examples of why Microsoft Access is great for business, listen and let me know your thoughts. Missed the first episode? You can find it here. [...]
Follow Me on Twitter During the Microsoft MVP Summit Next Week It’s time to visit the mother ship again, a yearly ritual both Ben and I relish as part of our MVP title, where the Microsoft Access team will share the latest, (often under NDA, sorry), I get to meet my peers from around the world and d [...]
Using ADO Asynchronously in Microsoft Access to Speed up Forms Our presenter for the next meeting, on March 12th, is Ben Clothier. Ben will talk to us about using ADO asynchronously in Access. Have you had scenarios where you need to load large amount of data but you don’t want to make users wait f [...]
