fbpx

Access queries help and tips

How does Access talk to ODBC data sources? Part 6

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 [...]

2021-12-19T06:14:09-06:00December 20th, 2021|

How does Access talk to ODBC data sources? Part 5

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 [...]

2021-12-20T12:29:27-06:00December 19th, 2021|

How does Access talk to ODBC data sources? Part 4

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 [...]

2021-12-30T06:47:12-06:00December 18th, 2021|

How does Access talk to ODBC data sources? Part 3

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 [...]

2021-12-19T23:16:25-06:00December 17th, 2021|

How does Access talk to ODBC data sources? Part 2

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 [...]

2021-12-19T23:11:10-06:00December 16th, 2021|

How does Access talk to ODBC data sources? Part 1

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 [...]

2021-12-18T11:19:39-06:00December 15th, 2021|

Evaluating when an expression in a query is evaluated

I've always found Itzik Ben-Gan's excellent chart on the logical SQL processing immensely helpful in reasoning about the querying performance. Even though the chart was made for SQL Server, it still is applicable to any database engine that follow SQL Standard, which also includes Access database en [...]

2022-04-19T04:00:03-05:00December 6th, 2021|

Using SQL Views to Add/Edit Data in Microsoft Access

Using SQL Views to Add/Edit Data in Microsoft Access This is part II of a two part series on views I've written, you can see part I here. Over the last couple of years I have had a great deal of experience with working on Access Databases with the Data is linked to tables in stored in SQL Server. Wi [...]

2022-01-07T08:59:56-06:00September 25th, 2018|

Find All Queries That Use a Particular Table

Find All Queries That Use a Particular Table We just completed a massive 39 database conversion to SQL Server for a client in Tennessee which was quite challenging, we had to not only upsize all the tables, but switch the system from importing/exporting between databases to using linked tables inste [...]

2022-01-07T08:54:50-06:00June 6th, 2016|

Reporting More Granularly Than Usual – Microsoft Access

Reporting More Granularly Than Usual - Microsoft Access Typically, when we do reporting, we usually do it at a higher granularity. For example, clients commonly wants a monthly report of sales. The database would store the individual sales as a single record, so it's no problem summing up the figure [...]

2021-06-11T07:39:55-05:00September 29th, 2015|

Access User Groups

The purpose of this group is to create virtual chapters throughout the world, from beginning user groups to advanced topics such as SQL Server. Chapters can be organized around a language, such as Spanish, a region, such as Spain or a topic of interest, such as Access functions. We hold monthly meet [...]

2014-07-14T22:52:49-05:00June 16th, 2014|
Go to Top