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 [...]
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 [...]
Analyzing the key population query some more In part 3 of our ODBC tracing series, we are going to take a further insight into Access managing keys for ODBC linked tables and how it sorts and groups the SELECT queries together. In the previous article we learned how a dynaset-type recordset is in fa [...]
UPDATE: Added some more clarifications around the meaning of SQLExecute and how Access is handling the prepared queries. Thanks, Bob! What's Access doing when we browse and look at records in a ODBC linked table? In the second part of our ODBC tracing series, our focus will turn to the impact the re [...]
This is a six-part series of articles on ODBC tracing to help Access developers troubleshoot and work with Access when developing an application that uses ODBC data source(s), usually but not exclusively SQL Server. The series aims to demonstrate how to use the ODBC tracing to monitor ODBC SQL state [...]