"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

Applies to: Access 2010

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.

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.

Workaround


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

Status


This behavior is by design.

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"