Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. "The compact and repair operation has been cancelled" error message when you try to compact an Access database file that is saved in the offline cache

"The compact and repair operation has been cancelled" error message when you try to compact an Access database file that is saved in the offline cache

View products that this article applies to.

Symptoms

Consider the following scenario:
  • You open a Microsoft Access database file that is located on a network file server in Microsoft Access 2010.
  • The file is always available offline.
  • You disable the network, and then the file is saved in the offline cache on the computer.
  • You try to compact the Access database file.
In this scenario, the compact process fails. Additionally, you receive the following error message:

The compact and repair operation has been cancelled. You might not have adequate permissions to the folder that the database is located in. You need full permissions to the directory the database is located to compact and repair. Contact your system administrator for more information.

Notes
  • This issue still occurs after you re-enable the network. 
  • After you clear the files in the offline cache and then restart the computer, you can compact the file.

↑ Back to the top

Cause

This issue occurs because a new file is created in the offline cache when you try to compact the Access database file. However, Access 2010 cannot process a new file that is located in the offline cache.

↑ Back to the top

Workaround

To work around this issue, save the Access database file in a folder that does not cache offline files.

↑ Back to the top

Status

This behavior is by design.

↑ Back to the top

More Information

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
252509 Error message: "Files of this type cannot be made available offline"

↑ Back to the top

Keywords: kberrmsg, kbsurveynew, kbtshoot, kbexpertiseinter, kbprb, kb

↑ Back to the top

Article Info
Article ID : 2834831
Revision : 2
Created on : 11/14/2019
Published on : 11/14/2019
Exists online : False
Views : 244