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

Deleting Records With Referential Integrity Set

P: n/a
In AccessXP in Access2000 mode ---

TblCustomer: CustomerID, CustomerName
TblOrder: OrderID, CustomerID, OrderDate
TblOrderDetail: OrderDetailID, OrderID, Detail

Appropriate relationships are established and referential integrity is enforced.

FrmCustomer/SFrmOrder is a form/subform based on the respective tables.

It doesn't matter if you put a button on the main form or a button on the
subform and it doesn't matter if you use the code:
DoCmd.RunCommand acCmdDeleteRecord

or

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

when you try to delete the current record in the subform and that record has
related records in TblOrderDetail, error 3200 arises as expected. Then it
doesn't matter whether you trap this error or not, when you next try and go to
another record in the main form using the navigation buttons, Access throws up
another error that says "Operation Not Supported In Transactions".

I checked other form/subform systems with a delete in the subform in the same
database as well as in several other databases and all acted the same way
throwing up the transactions error when trying to go to another record in the
main form after a deletion try.

Has any one else experienced this? Have you tried in your applications to go to
another record in the main form after trying to delete a record in the subform?

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.