Frequently Asked Questions
'Can't delete or change record. Since related record exists in table ='xxx'
Question:
"Can't delete or change record. Since related record exists in
table ='xxx', referential integrity rules would be violate"
error: What causes this error and how do I get around the
problem?
Answer:
The problem is that referential integrity is currently not
supported with the MSACCESS driver. Borland recognizes this as a
problem and is working on a solution. Currently, the only
workaround is to remove referential integrity from the MSACCESS
tables. You can see this behavior with Access 95 by changing the
RI value in the master table to the same value and trying to
post. Access 97 has fixed this problem.
LiveJournal
PhotoFile