Access - Referencial Integrity

[beltijs]

May i enable or disable de referencial integrity from Delphi?

I have Delphi 6 with ADO components (ADOConnections, ADOTables, ADOquery) and a .mdb file where the connection points to.

Paula

 

[lespaul]

Why do you think you need to remove the referential integrity of the database? That's not really a good thing to do.

What are you trying to accomplish? Perhaps there's a different way?

Leslie

 

[LucieLastic]

hi

Has Leslie says, you don't want to be disabling constraints on your database.

If this problem is arising when you're inserting/updating records, you're probably doing them in the wrong order for the db constraint. Update the table which doesn't have a constraint on it and then work 'upwards' or 'backwards' so the last table to be updated is the one with the constraint.

Hope that makes sense.

lou

 

[beltijs]

Well, my application has two 'ways' of working, so it has 1 parameter that establish the way it may work, If that parameter has same value, i'will like to enable same aditional constraints.
i'm trying to handle this aditional controls from Delphi considering that i agree with you that is not the right thing to change de database definitions, but it will be much easer for ME to add the constraints so this is handle by de database.

Paula

 

[LucieLastic]

hi Paula

Imho, I think you should leave the database structure alone and rethink your update method/routines. If you're finding it impossible to work with the current db structure then the structure(and constraints) may be wrong and need tweaking - Is the DB quite new or has it been running for some time?

Do you want to give us a better description of your current situation/problem and what you want to achieve and maybe you can compromise?

lou