Interested to Buy Any Domain ? << Click Here >> for more details...
Can you create a updatecascade, Deletecascade relation in
Ms-Access? If yes, give an example?
- 2 Answers
- 9207 Views
- I also Faced
- E-Mail Answers
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 |
What is lookup wizard access?
How does microsoft access database recover free space?
What can I use microsoft access for?
can primary key of one table be a primary key in many other tables
What happens if the both source and destination are named the same?
How can I give discount condition in a sales table in MS Access?
How is super key different from a candidate key?
What are the different parts of a database application called in access?
Does microsoft access still exist?
I assigned a primary key to my table in microsoft access, I was expecting my data to be sorted. Is that a right approach?
How can you create a form in ms access 2013?
What are the protection features in ms access?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
