• If you want a static copy of the data, use adOpenStatic when opening the recordset.

    Your issues might come from modifications done by concurrent sessions.

    -- Gianluca Sartori