Forum Discussion

Copper Contributor

Nov 19, 2020

Access 2019 Unable to Compact or back up DBs

Hi 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 ...

George_Hepworth

Silver Contributor

Nov 21, 2020

jadedalan
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?

jadedalan
Copper Contributor
Nov 23, 2020
also all my work is local
- George_Hepworth
  Silver Contributor
  Nov 23, 2020
  jadedalan
  That's puzzling indeed. I can think of nothing relevant that would be impeding the C&R.
  I will send out for the Cavalry...
  .
  - jadedalan
    Copper Contributor
    Nov 23, 2020
    It's not beyond the bounds of possibility that I'm doing something dumb, but I hope not
jadedalan
Copper Contributor
Nov 23, 2020
George_Hepworth
Hi George
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.

Resources