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 the advantage of ms access?
Does office 2019 include microsoft access?
Is it possible to retrieve all tables along with all the data?how?
How do I start microsoft access on my computer?
What are the advantages of ms access?
How do I create an access database from multiple excel files?
How many views are there in ms access?
What is ms access and features?
Is ms access hard to learn?
Is access faster than excel?
What is a null value in access?
What conditions he must fullfil before being accepted as a publisher?
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)