What does the primary key saying “On update restrict” mean?

Asked By jennina yale 20 points N/A Posted on - 03/08/2012

Is there any possible way of not allowing changes with the primary key? Something called ON UPDATE RESTRICT?

• Status: Open
• Question Views: 1246
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Kanhai Else 0 points N/A #90559

What does the primary key saying “On update restrict” mean?

The Fact you are dealing with has large connection to Referential integrity in relational database management systems. Referential integrity states Relationships between tables are valid. The main criteria are:

1. You cannot enter value in foreign key field of the Related Table that does not exist in the primary key (PK) of the primary table. However, you can enter a Null value/No value in the foreign key (FK).

2. You cannot change/delete a record from a primary table if the primary key value is used in records of an existing related table. MS Access 2003 enforces all the Constraints so that relationships are valid.

If you enter some records into the related tables then you can find that:

1. You cannot enter duplicate Primary key.

2. Cannot enter a foreign key value not present in Primary Key.

3. Cannot change/update a primary key value already used in a record as a foreign key.

If you are still facing the problem please look whether Cascade Update Related Fields is set. Disable it.

About Kanhai Else

Questions
0

Answers
56

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 03/14/2012
• Question Category: MS Access