I am experimenting with a query over the network for an in-development application. FE is access and BE is access.
With a test of 100,000 records, this query is very slow.
Fields of concern are: PK autonumber, OperationID, and version.
OperationID can be duplicative. Each record with a...