Deleting from a child-table

:rolleyes: Hi!
I've tried for a couple of days to manage deleting records from a child table. I´m connecting to an Access 2000 database through adodc-controls. No problem at all deleting from the parent-table, but when i´m trying to delete a recordset from the child-table, i´ll get a message like:
"Run-Time error '-2147217864 (80040e38)'
The right line for updating couldn´t be found.
Some values can have been changed sinced it last was read."

Could it have something with 'Date' (which i automaticly put in a textbox before creating a new record)?

Or did i miss something in Access, creating the database?

I would appriciate if someone could help me out with this;)

Check this and this knowledge base articles out. They may be able to help you.

Also as far as I understand the child tables are primarily for Reports and Heirarchy Grids not really for updates and that sort of thing. You can just change the data straight on the table itself and they should be linked via an ID just insert the ID with the update or delete from the table.

Thanks to both of you!!
Now i´ve got some ideas how to solve my problem, i´ll try this at once.
:)