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 |
What is microsoft access database engine?
What are the components of ms access?
What is the difference between form and report in ms access?
How do I get microsoft access 2016?
How do you use excel for access?
State some criteria and their effects of a database?
Is access good as a database?
What is data types in ms access?
What is microsoft access and its uses?
How many rows can an access table hold?
Would you like to easily automate your MS Access database through menu driven selections?
How can we create a simple query 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)