Novice question about multiple user input

burnfly

Registered User.
Local time
Today, 05:25
Joined
Feb 6, 2013
Messages
29
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!!
 
You don't need separate forms for each user. You just need one set of common forms that everyone will use. What you do need though is to give each user his own personal copy of the FE that they store on their own C: drive. The only thing that gets shared is the BE on the server. The users should NEVER share a common FE on the server. If necessary, they could use a personal FE from the network but that just adds overhead because all the Access objects need to be downloaded from the server in addition to the data. It is better to just have them store their FE on their C: drive and avoid that altogether.
 
I believe what you write is how I have it set up. I have a copy of the FE on each local computer. Not the network. Only my BE is on the network drive.
 

Users who are viewing this thread

Back
Top Bottom