472,342 Members | 1,581 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,342 software developers and data experts.

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


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?

Nov 12 '05 #1
0 2375

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: tom | last post by:
I am new to SQL administration. >From a list of IDs that are the primary key in one table (i.e. Customer Table), I want to make changes in tables...
by: Alex | last post by:
Hi, I have two tables , A and B where table B has a foreign key constraint to table A. I want to delete all records in table A that are older...
by: Steve | last post by:
See my post with the same subject about 5 hours ago. Is there a method or something to reset everything or cancel the attempt to delete a record...
by: Steve | last post by:
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...
by: Mark | last post by:
This question refers to a main form with a continuous form subform. After an error occurs after entering several records in the subform, how can I...
by: dmkeith2 | last post by:
Hi, I've posted this question to other forums and have had no luck. I'm currently creating a database for someone who is private investigator....
by: KC | last post by:
Hello, I am using Access 2002. WinXP, Template from MS called Orders Mgmt DB. I have tweaked this DB to work for our small co. It has worked...
by: bikkaran | last post by:
Hi , I have a table that contains 15lakh records..... I want delete that table....and insert fresh set of record. when I run the command...
by: Ron | last post by:
Hi All, Using Access2000, winXP. Table 1 = tblClients displayed on frmClients via qryClients. 2nd table = tblInvoices shown on frmInvoices...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.