I'm looking for a good way to swap to records within a recordset. When I've tried the traditional way of swapping I get an access violation error becuase of duplicate primary keys.