Unanswered: Adding a new record to a sorted recordset
Is there an option or property that can be set that will tell the ado recordset NOT to sort new or modified records in a sorted recordset? Meaning that if I add a new record, I want that record to remain at the last absolute position in the recordset. If I modify a sorted key field, I would like it to remain at the same abs position. I need a way to turn off the sort but keep the recordset sorted.