I'm working on a solution which will live on a network drive, to be accessed by multiple users asynchronously. Specifically, I have several "database" tables that users will add rows to, where the rows then contain links to their full submitted datatable.
Is there any built-in way to manage file access permissions in a situation like this? I want to avoid a situation where a user opens the "database" table and forgets to close it, locking everyone else out of the tool. I could code in my own variation on a mutex, but I don't want to reinvent the wheel if there is a built-in, easy solution. The ideal solution would be some sort of JSL script that sends a row of data to a data table without taking the lock on the data table.