audit trail in Word

[Doug Rope]

the knowledge base has a procedure to create one using a
memo field; i need something larger, like Word. anyone
know how to do this, maybe using OLE?

 

[John Nurick]

Hi Doug,


A memo field can store up to 1 gigabyte; isn't that enough? Using
something like Word would be horribly difficult and impossible to make
tamper-proof.

A better approach is to use a separate table to store the audit trail.
See http://www.mvps.org/access/modules/mdl0021.htm for an example.