VBA (Visual Basic for Applications) Question:

Explain four different cursor and locking types in ADO and describe them briefly?

VBA Interview Question
VBA Interview Question

Answer:

Cursor types:1. Forwardonly, 2. Static, 3. Keyset 4. Dyanmic

Lock types : 1. lockpessimistic, 2. lockoptimistic,3. lockbatchoptimistic 4. lockreadonly


Previous QuestionNext Question
What is insert module and Goal Seek functions present in VBA?Explain Which controls have refresh method, clear method?