I have a large database for one user with global fields to insert letter headers and footers and other personal information into invoices letters and other documents.
In order to be able to modify the information without bringing the database out of the server, the global fields are populated by a script when the database is opened.
I am trying to make this database work for different users adapting the privileges so they can only see the records they have created.
I can modify the opening script so the details of that user are inserted into the global fields on opening the file.
My question is what will happen when two users with two different settings are working on the file at the same time. If there is a conflict how can I avoid this.