Q. What is the difference between ‘Open’ and ‘Open Exclusively’?
-
(A)
Open statement opens access database files and Open Exclusively opens database files of other program like Oracle
-
(B)
Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed
-
(C)
Both Open and Open Exclusively are same
-
(D)
Open Exclusive command does not exist in MS Access
✅ Correct Answer: (B)
Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed