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

access

developer

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
    I've already mentioned this, but it may be worth repeating - I only bought this 'standalone' version (2019) of Access about a week ago and it hasn't worked from day one