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

[Susan Harkins]

So, what was the actual problem? :)

Susan H.

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