• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 474
  • 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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