Sorry I forgot one more thing:  I noticed that Karen's tbl_log (and the code that writes to it) doesn't include the PK(s) for the table the change came from.  This...

Hello forum,

I have a couple comments on Karen's posting.  First, bravo for taking on the hotly controversial topic of handling change logging with triggers - only the brave tread here.  And...

I'm almost shocked that a site like this by a private company hasn't already been shut down.  Steve - you hit the nail on the head, but not hard enough! ...

KC-

You didn't mention what version of Access you are using, but if you have Access 2000 available I would also try the Upsizing Wizard from Access and "push" the table up. ...