A whole week on the Microsoft Campus Once a year I trav el to the mothership, (Microsoft Headquarters), where I get to mingle with other MVPs across the world and learn the latest and greatest on AI and of course, Access. On Monday I booked time at their great studios to record my session on AI with [...]
Join Us for a Hands-On AI Workshop in Akron, Ohio AI is everywhere—but for many professionals, it still feels confusing, overwhelming, or out of reach. You’ve probably heard about tools like ChatGPT and Microsoft Copilot. You might even be experimenting a little. But the real question is: How do you [...]
This month we will be discussing how to leverage SQL Server stored procedures in Access: - Reports - Code - Passthrough Queries For more information on how to connect to the meeting please visit Access with SQL Server Meeting Info https://youtube.com/shorts/QPtoW050B9I?feature=share [...]
A lot of material has been created in support of using functions in Access queries. They are a key feature in making Access queries the powerhouse of data processing that Access is famous for. Just making an AI inquiry about “Using Functions in Access Queries” brings up a wealth of blog artic [...]
In a surprising turn of events, Microsoft has announced that Visual Basic for Applications (VBA) will now be known as Visual Basic for Applications with AI (VBAAI). This revolutionary change is set to take effect immediately, bringing a wave of excitement and confusion to developers worldwide. John [...]
As a computer consulting firm specializing in Microsoft Access, we understand the critical role that performance plays in your daily operations. Recently, we've encountered a significant issue affecting clients using Microsoft Access on Windows 11 version 24H. This bug has led to noticeable slowdown [...]
Building connection strings is a common task in an application development. In the previous article, I talked about differences among various connection formats. This brings us to the topic of building a connection string. Most of the time, it’s typically the developer of the application who will bu [...]
We get calls all the time to take over an existing database, for a wide range of reasons: Existing developer has retired. Does not have the skillset to cloud enable the database. Does not return calls/too busy. It is the hardest thing to do Taking over someone else’s work is not easy, oft [...]
When working with databases, it's essential to understand the different types of connection strings available and how they function. Let’s explore the differences between an Access external data connection string, an ODBC connection string, and an OLEDB connection string. Because they all use the sa [...]
This year, I had the privilege of helping host multiple sessions at Microsoft Ignite, the annual conference where the tech giant showcases its latest advancements. It was an extra-special experience, as the event took place in my home city of Chicago. If I had to sum up the conference in one word, i [...]
We've been receiving reports of Access not closing correctly on various versions. As far as we know, this impacts those on current and monthly enterprise. Those on the build 2408 will find that the Access no longer closes correctly and instead leaves behind a ghost process that needs to be killed in [...]
