Adding Constraints with Cascade

J

Jen

Hi Glenn,

Are you trying to set Integrity rules? If so, what kind
of errors are you getting. Could be that the foreign key
exists in your 'many' table, but doesn't appear in
the 'one' table - which violates the referential integrity
you're trying to set.

Regards,
Jen
 
T

Tim Ferguson

I can run
"ALTER TABLE Table2 ADD CONSTRAINT C1 FOREIGN KEY (FieldID) REFERENCES
Table1"
and the relationship is created fine but...
"ALTER TABLE Table2 ADD CONSTRAINT C1 FOREIGN KEY (FieldID) REFERENCES
Table1 ON UPDATE CASCADE ON DELETE CASCADE"
Comes up with a "Error in Constraint" message when I try to run the
code
Click to expand...

I think I answered this in tablesdbdesign: try using ADO and jet 4 instead
of DAO and jet 3.6. The cascade commands are not implemented in jet 3.6.


HTH


Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Refrential Integrity 5
Deleting/Creating a relationship between two tables -----> Help Pl 1
Update and Delete cascade 0
Referential Integrity in CREATE TABLE command 6
Joins & Cascading 4
On Update cascade 7
Overriding constraint violation message 8
Add constraint returns syntax error on constrain clause 7

Top