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

[Stuart McLachlan]

The lock file is created by Access in the same directory as the database  when the first user 
opens the database, it is modified every time a user opens or closes the database.  It is 
closed when the last user closes the database.

All users need create,modify and delete rights to the directory containing the database.


On 22 Sep 2016 at 10:07, John Clark 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
>