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