By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,600 Members | 943 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,600 IT Pros & Developers. It's quick & easy.

Deleting Records With Referential Integrity Enforced

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.