RpbertS
It is certainly possible - I have it working OK keeping an audit log of a table (Access 2000).
It took me a couple of days to get it sorted, but this was entirely due to my typos when substituting my table names for those in the example.
I followed the detailed instructions at: http://www.wa.apana.org.au/~abrowne/AppAudit.html