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 are data types in ms access?
can ms access be used in a website instead of sql server?
What is an access macro?
What are the features of ms access?
Is microsoft access difficult to learn?
How are queries run in ms access? List different ways.
Is microsoft access a good database?
Would you easily automate your ms access database through menu driven selections?
Which type of object is used to organize and store data in microsoft access?
What are the main differences between the two?
What is the size limitation for an access database?
What is the use of pivot table?
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)