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 [...]
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 [...]
It is common to run across questions about how Access handle deletions, particularly from the VBA code. The Access form provides 3 events around the deletions but they are easily misunderstood. I attribute this to how the events are presented in the Property Sheet's Events tab: If all we did was jus [...]
We got a pleasant surprise when one of our clients reported to us that the application was no longer. In this case, it had a .NET DLL that called Azure service. The code was very straightforward; just reference a nuget package provided by Microsoft and call methods on it and it just works™. Few mont [...]
It appears that users who are on semi-annual channels are getting impacted with bad update that breaks the ability to export or output data into other formats. This appears to be coming from the same update that had more reports about broken references, non-working ACCDE files, and DAO.Field3. Danie [...]
As a FYI, Microsoft has issued another update to current channel (Build 2204) which apparently contained changes that causes the otherwise functional Access application to stop work and throw errors. You may see the following error messages: * Property not found * No current record. * The search key [...]
Recently, Microsoft released two new drivers for SQL Server, a major upgrade: ODBC 18 Driver for SQL Server OLEDB 19 Driver for SQL Server That's great news! However, there is a major breaking changes that requires your attention. Specifically, they changed how the default settings work for the encr [...]
Microsoft Office 365 Build 2201 Causes Access Applications to error We have received reports and confirmed with Microsoft there is an issue with Microsoft Office 365 build 2201 that causes Access applications to fail with errors usually at the startup but also during use. Because the update is now b [...]
Effect of joins in a recordset In our sixth and final article of the ODBC tracing series, we are going to take a look at how Access will handle joins in Access queries. In the previous article, you saw how filters are handled by Access. Depending on the expression, Access may choose to parameterize [...]
Filtering the recordset In part 5 of our series, we will learn how Microsoft Access handles implemented filters and integrates them into ODBC queries. In the prior article, we saw how Access will formulate the SELECT statements in the ODBC SQL commands. We also saw in the previous article how Access [...]
What's Access doing when an user make changes to data on an ODBC linked table? Our ODBC tracing series continues, and in this fourth article we will explain how to insert and update a data record in a recordset, as well as the process of deleting a record. In the previous article, we learned how Acc [...]