I think the best bet is to use something that writes the changes after update but I don't know where to start looking, nor do I have an real experience with writing VBA script or macros. I have found some older stuff on Audit trails but I can't find any working scripts for 2010.
Any help you guys can give me would be great, even if it's only showing me how to append one record on update, I can figure how to do the rest from there.
INSERT INTO test ( Afterdata ) SELECT Table1.here FROM Table1;
I know this is the very basic append query code,
Would I be able to use something like this to compare then INSERT into the table?
SELECT ( u1.item1<> u2.item1) + ( u1.item2<> u2.item2) + ( u1.item3<> u2.item3) FROM table1 u1, table1 u2 WHERE u1.id = x AND u2.id = y
I dunno, I am kind of grasping at straws now.
Thanks for your help though.