Compact Repair not Accessible - Access Developer 44 Lessons


	Back to Access Developer 44 Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Compact Repair not Accessible

Ester Grande

20 months ago

Hi all, in my db I Have disallowed in the access options the shortcut menu (rightclick mouse). I have created an admin form where there are two buttons and by clicking them I allow or disallow the use of the shortcut menu so that as admin I can use it

This is the code to allow and to disallow it

'Allow
Private Sub ShowMouseBtn_Click()
    CurrentDb.Properties("AllowShortCutMenus") = True
    CurrentDb.Properties("AllowFullMenus") = True
  End Sub

Same code with false to disallow it

Now, in order to take the change the db needs to be restarted. I tought to use the compact and repair button, but if the menu is disallowed, in the ribbon I can't reach the compact and repair button. I tried to make a custom ribbon, adding the compact and repair button , but even though I see the button, that doesn't do the action. (here is the xml)

Basically if the shortcut menu is disallowed there is no way I can restart the db unless I close it and reopen it manually which I wanted to avoid.  How to solve it?

Kevin Yip @Reply

20 months ago

It isn't so bad to manually close and restart an application, is it? You have to do that with almost all applications anyway. I can't think of an application that has an "auto close and restart" feature. If you have to have that feature in Access, you likely need to create and run an external script (batch file, VBScript, etc.) that detects the closure of Access (.laccdb disappearing) and reopen Access. It's a cumbersome way to save just a couple of mouse clicks to reopen Access yourself.

	Ester Grande OP @Reply 20 months ago
Thanks Kevin, I just do it manually

Richard Rost @Reply

20 months ago

Yeah, I agree with Kevin. Then, it's not actually that much work to just close the database and reopen it manually. But if you wanted to do it this way, you would have to Shell out to something else that would then reopen your Access database. That's how I do it with my Access Updater. It opens another database that waits for the first database to close, performs the update, and then it relaunches it and closes itself. You don't need something that complex; you can do it with a simple batch file or PowerShell script.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer 44 Lessons.

Next Unseen