I am trying to create a small simple applikation in VB 6.0 that connects to an Access 2000 database. Everything works, except when i´m trying to delete a record from a child-table.
I have created a cascade on delete from the parent-table, and it works without any problems.
When a deletebutton is pressed the following function is called:
Function Delete_Snake (dat as ADODC)
Dim YN as Integer
YN = MsgBox ("Warning! Do You really want to delete this record?", vbYesNo+vbCritical,"Warning!")
If YN = 6 Then
dat.Recordset.Delete
End If
End Function
There is no problem deleting a child-record within Access.
Rem. I have 5 ADODC "children" controls on the same form and one master. I don´t have any problem in inserting new records to the children...
Please help....
P.S.
I´m using textboxes for displaying the attributes (including PK)
D.S.
![]()


I am trying to create a small simple applikation in VB 6.0 that connects to an Access 2000 database. Everything works, except when i´m trying to delete a record from a child-table.
Reply With Quote
Right now i am working x-tra at the hospital, but if i remember it right i´ll get a message like "can't delete, mising update..."