G'd evening Sunshine,
I'm not aware that the read only mode can be set at connection level. You may use the workgroup security, the windows explorer security, a protected form, etc.
To avoid the "open exclusively" issue split your db (FE and BE) so you redistribute localy the FE.
G'd luck