[AccessD] Back-End DB is locking...WHY?!

Hi John,

I've used split systems for years, and whenever anyone opens the FE, the BE
locking file always appears.  However, I am using .mdb's rather than
.accdb's, and that may be the difference.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Tuesday, January 14, 2014 1:27 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Back-End DB is locking...WHY?!

I just inherited a program from someone else...a non-programmer, who used
some of MY original code and thought she was a programmer...very sore
subject...especially today.
 
Anyhow, she had three people sharing a single Access DB (.accdb) on a common
network drive. Somehow it was working for them...until it wasn't. The did
some cleaning up of their file structure the other day, and they renamed
some directories, and it no longer worked. 
 
I told them that I was surprised it was working in the first place, and that
I wouldn't spend time figuring out "why" but I'd fix it the right way. To
make a long story short, I got all the tables into a single DB and then used
database splitter to create a front-end/back-end situation. 
 
This is the first time however, that I am seeing a back-end gain a lock file
(.laccdb).  I split the DB, yet it is still a single-user program...and I
have no idea why.
 
I suspect...but I'm trying to keep an open mind...it has something to do
with the fact that it was a "front-end" program of my original that she used
at the beginning...her beginning anyhow. 
 
Does anyone have any idea what I can look at to prevent...stop...this from
happening? Please help someone who is having a very bad day...
 
Thanks in advance!
 
John W Clark
Computer Programmer
Niagara County

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.