[AccessD] Basic Question (Probably) that I just don't know

Jim Lawrence accessd at shaw.ca
Fri Sep 23 16:00:27 CDT 2016


Just a WAG. 

You are the only one with read-write-create-file access to the MDB directory. A lock-file is created when a user with create-file capabilities accesses the database. As none of the users, other than yourself, have such create rights to the DB directory, no one, other than yourself, can create the lock file. 

I would suspect as soon as the other users will be given create rights to the directory everything should work fine.

HTH
Jim

----- Original Message -----
From: "Zyterra" <delam at zyterra.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Thursday, September 22, 2016 7:27:46 AM
Subject: Re: [AccessD] Basic Question (Probably) that I just don't know

I had a database many years ago. It was in a directory that I had read write access to, but other users only had read access. If I opened the database first, there would be a network lock file created and everyone could get in the database without any issues. If one of the read only users got in first, then only they could use the database unless they completely logged out and I opened it. 

Hope this is close enough to give a clue on this situation.  

Debbie

I cannot be perfect, but I can choose to be better than I was yesterday. 

Sent from my iPhone

> On Sep 22, 2016, at 9:07 AM, John Clark <John.Clark at niagaracounty.com> wrote:
> 
> I was asked a basic question today that I was a little embarrassed I did not know. I just never really needed to know because of how I develop things, but this was an end-user that uses Access and ran into a problem.
> 
> As you all know (I think), the proper way to create a multi-user Access DB is to split it into a back-end DB with all the tables and such in a common spot, and then give each user or workstation a copy of the front-end with forms/queries/reports to run locally. She has created several small databases that she shares and has had no issues...except for one...and she wants to know why.
> 
> I know it has to do with the lock file, and I have wondered why sometimes this works and other times it does not, but it was never really something I NEEDED to know, because my way doesn't present this issue. And I understand that her DBs are so small...in data and usage...that splitting them is sometimes more trouble than it is worth for her. 
> 
> So, can someone please educate me on the lock files and what I am missing...please?!
> 
> As it stands I am guessing that has something to do with location of the file...perhaps user rights to that location, or maybe as simple as how/where the lock file is being placed...?
> 
> Thanks ahead of time!
> 
> 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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list