Home All Groups Group Topic Archive Search About
Author
31 Oct 2005 7:50 PM
mrslavel
how do you unlock a recordset in access 2000

Author
31 Oct 2005 8:11 PM
Rick B
What does your question mean?

Please give us some details here.  Why do you think your recordset is
"locked"?


--
Rick B



Show quoteHide quote
"mrslavel" <mrsla***@discussions.microsoft.com> wrote in message
news:715D66DC-66E1-45D1-95F1-A53F8456375C@microsoft.com...
> how do you unlock a recordset in access 2000
Author
1 Nov 2005 2:05 PM
Chris Mills
If you refer to Tools, Options, Advanced, Default record locking, you can
choose the type of locking which I think is automatically unlocked when the
record is saved.

For recordsets, I don't think there's any inherent locking as such. You can
use BeginTrans, CommitTrans, and RollbackTrans, though how well they work I'm
not really able to say. (I use them, but then I've never struck an error
*related*)

Chris

Show quoteHide quote
"mrslavel" <mrsla***@discussions.microsoft.com> wrote in message
> how do you unlock a recordset in access 2000