updating a recordset but not the db itself (asp+access)

[avivit]

Not sure I'm in the right forum, but anyway:
Is there a way of updating a recordset of db in access, but not to update the database itself?
I'm using asp pages.

To be clearer: I need to update a certain field in a database,
just as long as the asp page is accessed, but I don't want this update to take effect when a user is out of this asp page.
So I thought of creating A RECORDSET and update there this certain field in part of the records, but want no effect on the real db.

Btw - For what u r about to propose. Do I need a write permission in the database, if not really updated?

Thanks in advance

 

[jasonsalas]

Have you looked into running an Access append query? You might be able to extract5 the desired data, and then add it to the end of an existing table. Is this what you were shooting for?

If you use ASP, you could use a SQL INSERT statement, but this would essentially add data to the table, which you said you don't want to do.