Search results

I should add that the other networked computers have no trouble opening the forms and updating data to tables, etc... But, if they are trying to do it at the same time = fail.

This could be the area that I am most novice about. I don't believe that I have set any restraints on the database or network. I'm not *totally* sure where to check all of that though. ?

Thanks for the reply. Hmmm. Ok, well... can a query lock the BE? I'm trying to isolate why I keep getting the "locked by another user message" (especially when no data is being written/changed to any tables).

Does a (the) .ldb file have to be closed for another user on a network (separate FE linked to network drive BE) to read/write info to a table? Or even select info from a table? thanks and thanks!

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.

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...

Thanks a gazillion! That did the trick!

Warning - this is massive. :D SELECT Events.EventID, Events.EventName, Events.EventDescription, Events.Location, [Fee Schedules].FeeDescription, Categories.CategoryName, Registration.RegistrationID, AgeDivisions.AgeDivisionDesc, AgeGroup.AgeGroup, Registration.EntryNumber...

Hello all. A bit of a novice user question here. I have a competition ranking contestants. A contestant can compete multiple times, each time with a unique registration number. I am trying to sort by score to rank the contestants, however the contestants can only receive one rank - their...