Below is what I think and have questions about. Hoping others can confirm, correct and complete. Many thanks.
In Access 2010...
File, Client Settings, Advanced section there are several settings...
Default Open Mode - Clearly for multi-user this has to be shared - mentioned for completeness
Default Record locking option group (No Locks, All Records, Edited Records) - The options are well defined and the internet/help but what does it really do? It seems to set the RecordLocks property on supporting objects when created. Is that it or does it do something else? I guess the point being is I don't think this is a global setting like Default Open Mode it is rather the default behavior for new things.
Open databases by using record-level locking - I believe this is a global setting for Access.... However I think it behaves differently for MDB's and ACCDB's. For MDB's I think it fills the record to the page size (2K for MDB?) and for ACCDB's I think it works without bloating?