We help IT Professionals succeed at work.
Get Started

lock file not updated or not closed for accde, how can this be prevented?

Sabina_Compassi
on
432 Views
Last Modified: 2015-02-09
I have a problem on the network drive where my access database resides split in a frontend (accde) and data-backend (accdb). Multiple users are using the same frontend to get to the data.

I have observed, that a lock file is generated (see below why I think so), that prevents the frontend retrieving the data of the backend. The frontend can be opened without problem, the error occurs, when actions are made, that require data from the backend.
This only happens, when the frontend database is an accde database. No issues observed with a frontend that is an accdb.
After everybody closes the database (frontend and thereby the dataend), the lockfile (laccdb) persists. The lock file points to the frontend. After killing the lock file (with appropriate administrator rights, it is not possible to simply delete it), retrieval of data is possible again. Both using accde frontends or accdb fronends.  

While I know now, how to manage the issue when it happens (killing laccde with the appropriate rights), I would like to know how I can prevent this to happen. It seems that the likelihood for not updating the lockfile is higher with accde than with accdb. Why's that? What can I do?
(I cannot distribute the accdb frontend, it must be the accde).  

Thanks for any help you can give me
Comment
Watch Question
President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE