[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 473
  • Last Modified:

How do you compact and repair a sealed off database?

I have a database that has the ribbon hidden, the shift key disabled, the F-11 key disabled.  How do I get in there and compact and repair if the database has a problem?
0
Sasha42
Asked:
Sasha42
2 Solutions
 
Dale FyeCommented:
If the application is not open, you  should be able to use the CompactRepair method from the Immediate window of another Access application.

After making a backup, try:

application.CompactRepair "SourceFilename", "DestinationFilename", True
0
 
peter57rCommented:
(:-) Fix a problem with C & R?
That would be a novelty.  I can't ever remember C & R fixing any problem I had.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
You can't compact and repair the currently open database anyway.

  Just open Access without opening the app and you'll have access to the ribbon.

Jim.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now