Access 97-Archiving records to a separate table then edit.

[cervantes008]

Hello All. I'm having an issue and I've tried thinking of all the workarounds and haven't come up with a usable method.

I built a form that pulls info from a Pipeline table. I wanted to archive previous info onto a separate table and keep track of all the people that make edits.

Is there a way to copy the original info (before edits) and paste it into an archive table by way of a click() and then allow the others to make edits after securing the original info? This has been bugging me all week.

[DanielaTm]

Hi,
You must have an archive table, and you save the data into it simply calling an insert select statement.

You can use like this:
insert into TblArchive(fld1,fld2,...fldn) select frl1,fld2,..fldn
from TblOriginal