'Access database locking in read-only no ldb file, using excel ododb

I built an excel tool that captures information, our company has rolled it out to 500 users without telling me. It seems to work ok other than sometime the access database locks in an odd read-only mode, but there doesnt appear to be anyone in the file?

Excel does ODODB connection to access with this string:

  Connection.mode = 16 + 3  'adModeShareDenyNone + adModeShareReadWrite

Any thoughts on how to avoid these odd lock outs?

excel vba

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Access database locking in read-only no ldb file, using excel ododb

Sources

Related Questions