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