How to create a TransactionLog table?

[AccessBeetle]

I am building a database which is in MS SQL 2005. It has a front end in Access 2003. The tables are linked via DSN.
There can be several users at a time hitting an application. I would like to catch each and every activity that has been perfomed on each and every table of the database, something like a transaction log. Please, let me know how should I approach?
Thanks

[missinglinq]

This is not for the faint-hearted, but Allen Browne has a tutorial on Audit Logs, which is the usual term for this sort of thing:

http://allenbrowne.com/AppAudit.html

Linq ;0)>

[orangeCat]

Doesn't MS SQL 2005 include transaction logging? Wouldn't you use that instead of building something yourself?

[AccessBeetle]

Orangecat,
Where to look for it in MS SQL 2005? Sorry, this is kind of a dumb question but I am new to it.

[AccessBeetle]

Thanks Missinglinq, taking a look at it. but as Orangecat have said, if MS SQL 2005 builds the TransactionLog on it own than I would prefer that instead of implementing it in Access. Let me know how we can see it in MS SQL 2005.
Thanks

[orangeCat]

AccessBeetle,
I am not a SQL Server user, however, I have worked a lot with Oracle.
I did some searching and found this link to M$soft re MS SQL Transaction logging.

http://msdn.microsoft.com/en-us/library/ms190925.aspx

[AccessBeetle]

Thanks.That helps. Althought will have to do yet more research on that topic.

[orangeCat]

Thanks.That helps. Althought will have to do yet more research on that topic.

AccessBeetle,

I did a little more searching and have found a couple of articles that may be helpful to you. Since I don't know your DBMS expertise, nor potential applications, I am providing these links to help put transaction logging into context.
Good luck.

General transaction log concept: http://en.wikipedia.org/wiki/Transaction_log
Importance of the Log: http://www.craigsmullins.com/dbta_049.htm
This is specific to SQL Server:

http://www.databasedesign-resource.com/sql-server-transaction-log.html

[AccessBeetle]

Thank you. I appreciate your help !!