I have a split database for setting up competition events. I have added sections for scoring input and tabulations per registration entries. I would like to give three judges a front-end copy with distinct scoring forms and let them enter the scores. I have the BE file on a network drive, and the front end on network computers.
I have created an initial form, in which a user selects an Event via a combo box, and then the other forms/queries pull up via the selected Event from that combo box. This box/info stays open. All initial forms for each person are unique, however they all use an Event combo box. All of the combo boxes pull from a column in the same "Event" table.
My problem, is that upon one networked computer selecting an Event via a combo box, I get an error message "(can't save?).. locked by another user" on all of the other networked computers.
None of the forms have any Locking enabled. I have set "Allow Additions" and "Allow Deletions" on the forms to "No".
Is this an .ldb issue? I feel that somehow the .ldb is keeping the Event table locked when any combo box is selecting an Event. I'm not sure how to have a form pull up the correct information another way. ? Any thoughts? TIA!!
I have created an initial form, in which a user selects an Event via a combo box, and then the other forms/queries pull up via the selected Event from that combo box. This box/info stays open. All initial forms for each person are unique, however they all use an Event combo box. All of the combo boxes pull from a column in the same "Event" table.
My problem, is that upon one networked computer selecting an Event via a combo box, I get an error message "(can't save?).. locked by another user" on all of the other networked computers.
None of the forms have any Locking enabled. I have set "Allow Additions" and "Allow Deletions" on the forms to "No".
Is this an .ldb issue? I feel that somehow the .ldb is keeping the Event table locked when any combo box is selecting an Event. I'm not sure how to have a form pull up the correct information another way. ? Any thoughts? TIA!!