Is there anyway to log the activity of a user (i.e. tables modified, possible list of modifications)?

thanks

You will have to track this with a third party product. FMS (www.FMSinc.com) Detective or Using Microsoft SourceSafe.

Hi there,
Not sure if this is the kind of thing that you are after but I made some modifications (with a lot of help from a very kind forum member) and it works for me. Check out the code here: http://support.microsoft.com/support/kb/articles/Q183/7/92.ASP
Hope the link works!
Fiona