Opening independent recordset from a table

Hello,

I have a little problem whose solution I am pondering for a while.

I would like to open an ADO or DAO recordset from a table regardless of whether it is local or remote and perform some calculations on it, maybe even add some fields…etc

The important thing is: I do not want to affect the table that serves me as a source for my recordset.

Obviously I want to avoid creating a copy of the recordset.

No matter what I do with my recordset it will not affect the source table. It’s independent from it.

Does anyone have an idea?