Gary Kjos
garykjos at gmail.com
Thu May 16 13:34:51 CDT 2013
There is an option to open databases EXCLUSIVELY. That could be the problem as well I suppose. When somebody has the database open is there an LDB file appearing in the folder along with the MDB file? GK On Thu, May 16, 2013 at 1:19 PM, Gary Kjos <garykjos at gmail.com> wrote: > 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 > -- Gary Kjos garykjos at gmail.com