Gary Kjos
garykjos at gmail.com
Thu May 16 13:19:56 CDT 2013
Your users don't have file creation rights in the directory folder where the database resides. So it can't create the LDB lock file. That allows ONE user to open the database but not a second one. Users need full file creation, update and deletion rights for the directory the Access database is in. Creation to make the LDB file and Deletion to delete the LDB file when the last person closes it and Update to actually change the database. On Thu, May 16, 2013 at 1:13 PM, John Clark <John.Clark at niagaracounty.com>wrote: > There is probably actually two question here. One I want to confirm > something w/y'all, and then a 2nd is just something different that I am > seeing...or actually not seeing... > > First, I wrote this program probably 13-14 yrs ago, which our Hotline > people use to track "clients." Hotline is the line you call when you're > looking to do harm to yourself and others, and you are smart enough to ask > for help first, so its been used 24 hrs/day, 7 days/wk, for all these > years. I've tweaked a couple of things and made it work w/a couple > different versions over the years, but now, for the first time, they are > having the issue of only one person being able to use it at once. > > I was really just picking up Access at the time I wrote this, so I think I > just didn't have the whole "Front-End/Back-End" thing down. And, since then > I've just had the attitude, "if it ain't broke..." and have just left it > alone. > > But, they have two operators and they want them both using it. I told > them, "It really wasn't designed for simultaneous use by multiple people. I > know it DID work, but to be honest THAT is what the anomaly was, and not > that it won't work now." I've explained to them that I can, relatively > easily, make this a mutli-user program, and it would be relatively quick. > > I just wanted to pick the brains of this group first though. Basically, I > want to know the same thing they do...I just don't have an answer for > them...WHY did this work, as a single MDB, for all these years, and now it > just stops? > > And here is question 2...I remoted into the 2nd user's PC and I had user 1 > start the program. When I try to run it, not only will it not run, but it > is the first time I've ever gotten NO response...no errors...nothing...like > I'm clicking on a dead icon. I tried to run it right from the directory, > taking the shortcut out of the mix and nothing. As soon as user 1 exits the > program, I can enter normally again. > > I have always gotten an error when trying to run a program somebody is > already in, and never received no feedback at all. What gives here? > > Notice: This electronic transmission is intended for the sole use of the > individual or entity to which it is addressed and may contain confidential, > privileged or otherwise legally protected information. If you are not the > intended recipient, or if you believe you are not the intended recipient, > you are hereby notified that any use, disclosure, copying, distribution, or > the taking of any action in reliance on the contents of this information, > is strictly prohibited. Niagara County is not responsible for the content > of any external hyperlink referenced in this email or any email. > IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER > IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER > OR ELECTRONIC COPIES. > Thank you for your cooperation. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- Gary Kjos garykjos at gmail.com