[AccessD] Quick question for confirmation

Yep, I'd suspect file permissions too.

Has anyone moved the application or messaed around with the file system recently?


On 16 May 2013 at 14:03, David A Gibson wrote:

> I've put together several DBs for multiple users that have functioned well
> when being accessed by PCs.  We had trouble when we allowed Macs to access
> them as they sometimes corrupted the DBs and caused data loss.  I currently
> use Win 7 64/bit with MS Office 2010.
> 
> You can open a DB exclusively but that goes through a dialogue where the
> operator has to consciously check a box.  File permissions is a more likely
> culprit  for your single user issue.  
> 
> What version was this written in and has it been upgraded since?
> 
> David Gibson
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
> Sent: Thursday, May 16, 2013 1:14 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Quick question for confirmation
> 
> 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
>