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

Gary Kjos garykjos at gmail.com
Thu Sep 22 09:21:51 CDT 2016


Users need full access to the file location of the database.  The lock
file has to be created when the database is opened and later deleted
when the database is closed and so users need creation and deletion
privileges. If the the lock file can't be created then the database
will be opened exclusive and nobody else can open it until it's
closed.  Often the network people will give only read access or read
and update access and not allow creation or deletion.  This would also
be the case in split database situations as the backend database also
has a lock file that must be created when opened and deleted when
closed.  Normally seeing there is a lock file will tell you that
either 1) someone has the database open now.  or 2) someone did not
exit and close the database properly so the lock file could be
deleted.

GK

On Thu, 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



-- 
Gary Kjos
garykjos at gmail.com



More information about the AccessD mailing list