Accecss 2010 - laccdb BE lock file
Posted on 2013-11-03
I have 2 different projects for different clients. Bot are access 2010 databases with split FE and BE.
For the first client I added a 'compact and repair' button to the FE that would compact the BE if all other user are off. It works really well. The FE has an unbound form for various admin functions and this is where the C&R button sits. I have observed that the BE laccdb file appears only when the user has a bound form open, and disappears whenever they are on an unbound form (main menu, help screen, report menu etc). So, this is why they are able to C&R BE successfully - the BE is NOT locked.
I added same functionality to the second client, but the BE laccdb file behaved differently. Backend lock file does not get created until you move from unbound HOME screen to a bound form, but then, when you move off bound form, to unbound form the laccdb file does not disappear.
Both FE databases and both BE databases have the same client settings for record locking:
default: NO LOCKS is ticked, and 'open dbs using record-level locking' is ticked.
Why does the BE laccdb hang around when I move off a bound form in my second situation? How can I get a C&R function working?