Solved Compact And Repair Error

[bob fitz]

Can anybody tell me why I get this message box when trying to Compact and Repair the database. It is not split. It is on my machine. I am the only user>

 

[isladogs]

Its probably due to the recent Access bug that had supposedly been fixed.
Which version of Access are you using and if its 365 have you done the latest update to version 2203?

 

[bob fitz]

Its probably due to the recent Access bug that had supposedly been fixed.
Which version of Access are you using and if its 365 have you done the latest update to version 2203?

Hi Colin. Thanks for your interest.
I'm using Office 2019 Pro.
Any suggestions on how I can get the Compact and Repair to play nicely.

 

[isladogs]

Is it just that one database? If so, try decompiling First.
If its all databases, then check for recent updates which should fix the bug

 

[bob fitz]

Is it just that one database? If so, try decompiling First.
If its all databases, then check for recent updates which should fix the bug

Just this one, I'm pleased to say.
I'll look into how one decompiles a db and give that a try.

 

[bob fitz]

Is it just that one database? If so, try decompiling First.
If its all databases, then check for recent updates which should fix the bug

I've tried decompiling and then compiling it but I still get the error when trying to Compact and Repair.

Do you have any other suggestions, please.

 

[isladogs]

Try each of these in turn
1. Double check that there aren't two copies of the DB open
2. Open with the shift bypass so no code is running, then compact,
3. Open exclusive, then compact.
4. Compact it from another database
5. Compact it from File Explorer (see utility at Daniel Pineault's site) or using a command line switch
6. Import all objects into a new blank database then compact.

Don't forget to check for updates to 2019

 

[bob fitz]

Try each of these in turn
1. Double check that there aren't two copies of the DB open
2. Open with the shift bypass so no code is running, then compact,
3. Open exclusive, then compact.
4. Compact it from another database
5. Compact it from File Explorer (see utility at Daniel Pineault's site) or using a command line switch
6. Import all objects into a new blank database then compact.

Don't forget to check for updates to 2019

My apologies. This does seem to be happening with every db.
I have update switched off.

 

[isladogs]

Have you worked through the above suggestions in turn?
If none of those help, I suggest you turn on updates as it sounds like you are indeed affected by one of the recent bugs.
If you still have issues, repair or reinstall Office.

 

[Gasman]

Bob, are you using McAfee by any chance?

Cannot Compact And Repair Access Database – File Already In Use

Here's what to do when you try to compact and repair your databases and Microsoft Access reports "Could not use [filename] file already in use".

www.devhut.net

 

[bob fitz]

Bob, are you using McAfee by any chance?

Cannot Compact And Repair Access Database – File Already In Use

Here's what to do when you try to compact and repair your databases and Microsoft Access reports "Could not use [filename] file already in use".

www.devhut.net

yes

 

[Gasman]

yes

Read that link then.

 

[bob fitz]

Read that link then.

Thanks for your interest.
Can you offer any advice on how to create an exception?

 

[Gasman]

Most AV have a whitelist that you build to say you trust at that time?
I just use the free AVG, but a quick Google shows https://www.google.com/search?q=mca...3j0i22i30l6.9433j0j7&sourceid=chrome&ie=UTF-8

As Daniel indicates, just stop McAfee from scanning for a short while, while you try and compact.
Then if successful, set an exception.

 

[bob fitz]

Most AV have a whitelist that you build to say you trust at that time?
I just use the free AVG, but a quick Google shows https://www.google.com/search?q=mca...3j0i22i30l6.9433j0j7&sourceid=chrome&ie=UTF-8

As Daniel indicates, just stop McAfee from scanning for a short while, while you try and compact.
Then if successful, set an exception.

Many thanks to everybody for their interest, time, comments and advice.

Gasman: The link you gave me has enabled me to do what needed to be done. Many thanks

 

[cheekybuddha]

Out of curiosity, what do 3rd party AV providers offer that built-in windows defender and Windows firewall don't?

Aren't they just a drain on resources?