Deleting Records With Referential Integrity Enforced

S

Steve

For all who might have read my previous posts ----

AccessXP in 2000 mode and I presume in 2002 mode has a bug you might not know
about. If you try and delete a record in a subform where referential integrity
is enforced and cascade deltete is not set and then in the next operation try to
move to another record in the main form, you will get the error message
"Operation Not Supported In Transactions". This occurs because the link to the
subform is broken by the Delete attempt.

See KB Q295229

Steve
 
Top