Audit data before update in a table

[sssandhya89]

Hey guys,


I need to record the data before update in a table and the new data that has been entered in the table, kind of like recording old and new values of a table in another table. Can you please help me out with it?

Sandhya

[orange]

How experienced are you in
a) database
b) Access?

I see you are relatively new to the forum based on the number of posts.

Did you have this requirement before acquiring Access2013?
How big a requirement is this -- you may want a different DBMS that can handle (automate) transaction processing with backup and recovery.

Your question does not have a simple answer without additional info.

You can see a sample create auditlog here

For a broader picture and concepts see

[sssandhya89]

I am new to MS Access, i don want something really big that i need a different DBMS and all, i just need to record the changes made to a table in another Access table, it just needs the old value and the new value, it's pretty simple.

How experienced are you in
a) database
b) Access?

I see you are relatively new to the forum based on the number of posts.

Did you have this requirement before acquiring Access2013?
How big a requirement is this -- you may want a different DBMS that can handle (automate) transaction processing with backup and recovery.

Your question does not have a simple answer without additional info.

You can see a sample create auditlog here

For a broader picture and concepts see

[orange]

Then this link should be fine.
You can see a sample create auditlog here