469,640 Members | 1,561 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,640 developers. It's quick & easy.

Deleting Records With Referential Integrity Set

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
0 2215

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by dmkeith2 | last post: by
12 posts views Thread by bikkaran | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.