If another user is accessing a record with the RMS ODBC driver, am I locked out of that record?

No. Standard VMS record looking applies, several users can read the same record. However, if another user has the record locked for updating, your version of the record is the one before the update started.