Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

Global variable with recordsets

My task is to create a historical record of a database record change.  Example:  User opens a record.  Modifies it.  Saves it.  My history table should have record1, the original record before changes.  Then record2, the record after changes.

My plan:
User selects record to edit.
Save that record as in an array or recordset(?)
Edit record.
On save in history table save original record from array or recordset, then save new record.
Then save changes in original table.

There are about 50 fields.  I'm trying to avoid handling them one by one.

Does this plan make sense?  
Can I create a global recordset variable, save the original recordset to it, and then use it later?  Another way?  

Thanks,
Brooks
0
gbnorton
Asked:
gbnorton
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Brooks,

 Have a look at the following:

http://allenbrowne.com/AppAudit.html

Which is a complete drop in Audit trail solution.

Jim.
0
 
gbnortonAuthor Commented:
Thank you Jim.  Perfect.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now