title: What happens if you try to update a locked record in JET?
body: <p>If I use JET/DAO to open a recordset on a MDB database using <code>dbPessimistic</code> locking, what will happen if another user tries to update a row in that recordset at that time?  Will there be an error, or will JET/DAO keep trying until the row is unlocked?</p>