Nov 19 2020 04:28 AM
Nov 19 2020 04:28 AM
Help. I've recently installed a standalone copy of access. I have some experience of using earlier versions. Whenever I try to either compact or back-up a db, an error message tells me that my file is in use. I have eliminated the possibility of old lock files and have ensured the folders I'm using all have full permissions. I've also tried 'clearing the air' via a blank db as advised elsewhere. Whether I attempt to initiate this process from'Database Tools compact & Repair' or via 'Home/Info', the results are always 'Could not Use - file nnn already in use'. I realise that I can set 'Compact on Close' but this is not an answer and is no help at all for Backing up. Am I doing something obviously wrong?
Nov 20 2020 08:01 PM
I hope that helps.
Nov 21 2020 01:22 PM
Is this a problem with only one accdb, or does it happen with any accdb you open?
Does any automation code run at startup?
If not, does this happen if you open the accdb and immediately try to run compact & repair before doing ANYTHING else?
Are you trying to compact & repair an accdb in a folder on your local computer, or in a network share?
Nov 23 2020 12:53 PM
It happens with all dbs. Ones carried forward from earlier version of access, new-ish ones and a couple I've created just to see if I can make compact and back up work. I have db access set to 'shared'. If I try and start a compact whilst the db is open via the 'Compact and repair etc' icon on the 'Database Tools' toolbar then I immediately get an error. The same happens If I close the db and start a dialogue via 'file/info/open file location'. As soon as I select a db - the same error - 'see below' Everything I've said also applies to back ups.
Nov 23 2020 01:18 PM
Nov 23 2020 05:15 PM - edited Nov 23 2020 05:17 PM
I've seen this when the database was in a SharePoint library. Is that the case here? Even placing the file locally was not enough, I had to copy the file to another PC to unlock it to be able to work with it properly, then copy it back.
Nov 23 2020 07:11 PM
I notice that the screen shot you provided starts with a D:\ drive, although the rest is blacked out. Is D:\ a second hard drive in your computer? Or maybe a mapped drive? Maybe another location such as a DVD or CD Drive? I don't imagine that's the case, but to be thorough, let's identify the location to be certain.
Does this problem persist if you copy an accdb to the C:\ drive as well?
Nov 24 2020 11:51 AM
Thanks for all your suggestions. So - one at a time.
I'm left with the option to re-install, which I will when I get to grips with how to. Via the downloaded install exe I guess.
I've tried, both with the DB open (in shared mode) and with another db open, via the file/info/enter path. I'm presuming either of these should work (and neither do). Is this a correct assumption or is there a preferred route?
Nov 24 2020 12:31 PM
Good thought and one I hadn't had - unfortunately, nada. I'll reinstall. at least I can copy dbs via Windows explorer. I can't lose the thought that's it's something to do with running a standalone version, but then again, I can't be the only one.
Nov 24 2020 12:38 PM
Nov 24 2020 01:49 PM
Actually, the fact that this is the first time I've encountered an unexplained problem like this does suggest it's not related to having a stand-alone version of Access. Otherwise, we'd see more reports like it.
I think we covered this, but if you press and hold down the Enter Key while opening any accdb, and then IMMEDIATELY do the compact & repair before doing anything else, does that not work?
Nov 24 2020 01:59 PM - edited Nov 24 2020 02:00 PM
Have you rebooted your machine?
Is this a Microsoft Store (App) version of Access?
Have you tried a full Online repair?
If you go the route of uninstalling and reinstalling, be sure to use Option 2 from https://support.microsoft.com/en-us/office/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5d... to perform the uninstall.
Dec 02 2020 11:11 AM
FWIW, something just came up in another forum that might have some bearing on this problem.
The issue arises when a file is copied under Windows " ... and the file is not open, Windows places a full lock on the file during the copy.
If the file is an Access database, and someone tries to open it in Access either directly or via a linked table during the time it’s being copied, Access behaves as if there were read only. Non-updateable errors get triggered.
That seems okay, but a side-effect is that the database seems to stay locked by Windows. So even after the Windows file copy is over, there’s still a lock that prevents Access from editing the data. Closing Access makes no difference and there’s no laccdb or ldb lock file.
We’ve overcome the file lock by rebooting the server hosting the database but that’s a pretty drastic remedy. We had a situation where the database was sitting on an external hard disk from the PC, and unplugging the USB cable and plugging it back in seemed to cause Windows to break the lock, and was much better than rebooting it."
Another very long shot, but it might be worth considering as well. Assuming you haven't solved the problem otherwise.
Dec 02 2020 12:30 PM