On 27 Apr 2022 at 10:41, John Colby wrote: > Am I correct that any queries will pull the entire dataset and then > apply filters etc locally? > For a query written in Access operating on tables - yes. Look at using Stored Procedures, Pass Through Queries and Views to get MySQL to do all the work.