Can the following code be applied to Infopath when it's linked to Access in the back-end. For example: anytime I submit a change to a record in Infopath, can the pre-update record be copied to a historical table.
http://www.vb123.com/Toolshed/00_access/auditrecords.htm
I'm not a database expert, and know practically nothing of Access, however in SQL I believe you can write a trigger to copy out the previous row data when changes are made. Perhaps Access has something like that you can do?
Access doesn't have a built in functionality to keep historical data like that, it requires code. My organization wants me to create a working prototype with Access( lol) and then sell the idea to other business groups and get funding for some kind of server where we can use some SQL based app. For now I'm stuck with Access and Infopath. I really don't have the technical skills to build forms in Access. I'm much better in Infopath. I just wish I could run a similar code from infopath and pass it on to Access.