Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.
Not the Undo METHOD (so you can undo the record), but the Undo EVENT of the
Form (i.e. where Access notifies you that the record has been reset.)
There was a KB article on how to simulate an undo event for the form, but it
did not work reliably. A2000 introduced a true Form_Undo event that works.
Yes, if one is aware of the issue.
Yes, I did not word that clearly. I was thinking of the new JET 4 features
that don't work in the query interface or in DAO in later versions of
Access, so have to be executed via ADO.
You may be right: I don't recall getting caught when converting back to 97.
But I have been caught several times with a database I edited in A2003 and
the user is using A2000. The silent discard is not reliable, and actually
does corrupt the database and introduce bloating and hard-to-trace bugs. The
suggestion is to force the discard before converting back to any previous
version, but I have no evidence that this would be productive for a
conversion back to 97.
Yes, that's the way I remember it also, so I was surprised that A2003 did