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?
Sasha42Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Dale FyeConnect With a Mentor Commented:
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)Connect With a Mentor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.