Records on Microsoft Access form not sorted correctly
Posted on 2007-12-06
I have an Access form and the datasource is set to a linked SQL server table. Most of the time, the data is correctly sorted (form is for work orders, work order id is a primary key, int 4, identity, and also a clustered index). Every now and again, we'll have a customer call in because their work orders are not sorting correctly. We've looked at the form...done a compact/repair, replaced with a different front-end (mdb) but still not sorted right. You'd expect to be able to scroll incrementally through a recordset (work order 1, 2, 3, etc) but then it may place work order 150 at the end of the recordset and 155, 156, 157, etc somewhere in the middle. I'm not calling the data via a query - so the linked table is the datasource, not sorted in any way. I have a sort order on the form set to WorkOrderID. But still not in sequential order.