Can you create a updatecascade, Deletecascade relation in
Ms-Access? If yes, give an example?
Answers were Sorted based on User's Feedback
Answer / upendra agnihotram
Yes. You CAN. you need to set the referential integrity in
Relations window in MS Access. When you add a relation to a
table, you will be prompted through Edit relations window
where you can set the cascade updates and cascade deletions.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / susi kumar.p
After make ensure of having unique index for setting up
the "Enforce referential integrity" at relationships in MS
access we Can create a updatecascade, Deletecascade
relation in Ms-Access.
Try and let to share.
Note:- Good Upendra.A
Is This Answer Correct ? | 1 Yes | 1 No |
I assigned a primary key to my table in microsoft access, I was expecting my data to be sorted. Is that a right approach?
Is there a limitation on the size of a database that can be opened in microsoft access?if yes, what?
Who uses access database?
Is microsoft access user friendly?
Does office 365 include microsoft access?
Explain about the protection features present in MS Access?
What are the advantages of ms access?
When to use ms access vs excel?
You need to migrate the ms access database tables to oracle. What steps will you take?
What is microsoft access?
Which is better mysql or ms access?
What is dao recordset in access?