This topic is locked

Error: record cannot be deleted or changed

1/13/2005 4:25:06 PM
ASPRunnerPro General questions
B
baltrusj author

Anyone know what this error means and how to solve it?
[Microsoft][ODBC Microsoft Access Driver] The record cannot be deleted or changed because table 'STUDENT_CONTACT' includes related records.

Sergey Kornilov admin 1/13/2005

Hi,
this error message means you have a relationship in your database that prevents master record from being deleted if child table has related records. In this case you have to delete child records first.

B
baltrusj author 1/13/2005

So it sounds like I specified my master-detail (parent-child) tables incorrectly. Wonderful.