and waited for that transaction to roll back, this feature will be of interest ... When I switched the compatibility mode to 150 (using SQL Server 2019), the same query took 900 milliseconds ...

Using Access to build a front end for SQL Server Your email has been sent What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your ...