DAO dbOpenSnapshot Problem with Memo fields

K

KitCaz

I created an audit trail routine which compares a static
(dbOpenSnapshot)recordset captured in the Form_Dirty procedure against a
subsequent recordset captured in the Form_AfterUpdate procedure. I compare
each field's before/after values and write the adds/changes/deletes to a
special audit table.

This process is working perfectly except for memo fields. Any memo fields
captured in my Form_Dirty procedure are already dirty when the recordset is
created.

Why is that, and any suggestions how to proceed? I hate that I got this
routine working well only to discover this problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using DAO for the first time 2
DAO problem with Memo fields > 255 char long 1
Blank Field Problem with a NText (Memo) type of field 2
MSACCESS 97 APPLICATION ERROR CONVERTING FROM TEXT TO MEMO 4
Search Key Error, Memo type field 0
Audit Trail Code Not Using All Audit Types 1
static function and memo fields 1
Access VBA DAO Find routine on Form Combobox 1

Top