I'm moving an access database from all the data being in MS Access to MS Access being just a frontend, but I'm having trouble figuring out how to do a sort of column history.
I have a tasks.description column, and in another table descriptionLog, I have ID, Description, DateTime, and Task. Task is the ID of the task from the Task table. I was able to do this using data macros, but I need it to be agnostic from MS Access.
I've read a few guides on change tracking but I'm not sure how to get the data out.
Detail on column history: column history is a functionality of MS Access databases 2007 and up where you can set a memo column to be append only, keeping a log of what was entered or removed from the column.
