create log for table to capture changes by users

Hi all,



Is there a way of creating a log to capture changes in a table by users?

In a current database that I'm taking over, there was a lot of records deleted from the main table and now I need to figure out what happened.

So, if I would be able to have a log that recores all the actions taken by users, I could at least see who did what.

Any ideas to get me started and some links?



Greetings.

create log for table to capture changes by users