Remove the Customize in Access option from an Access app

Before you share an Access web app, you might want to lock the web app so other people can’t edit it. Locking an Access web app removes the Settings Office 365 Settings button menu in the browser view of the web app. After this option is removed, people can’t open the web app in Access, see how the web app is constructed, or edit it.

The Customize in Access option on the Settings menu shown crossed out

Note: This article doesn't apply to Access desktop databases.

If your Access web app is on an Office 365 or SharePoint Online site and you’re using Access 2013 with Office 2013 Service Pack 1 (SP1) or higher, you have the option of locking an Access web app when you’re saving the app for deployment.

Here are the steps:

  1. Open the web app in Access and click File > Save As > Save for Deployment.

    Note:  If you don’t see the Save for Deployment option, you don’t have the option to lock an Access web app. Your web app needs to be on an Office 365 or SharePoint Online site. You also need to have Office 2013 SP1 or higher installed on your computer.

    The Save For Deployment option on the Save As page

    1. Enter a title for the web app package and adjust the version number, if necessary.

      Create Deployment Package dialog box

    2. Make sure the Locked check box is selected to keep users from updating the web app that you distribute.

      Caution:  Before you lock your web app, make sure you save an unlocked copy of the web app. Otherwise, you won’t be able to open your web app for editing.

    3. Click OK, browse to the folder where you want to save the file, and then click OK.

    4. Upload the new copy of your web app to your App Catalog or the SharePoint Store, or upload the app straight to a team site.

Now, people who use this copy of the web app will not see the Settings Office 365 Settings button menu. You can open your own separate copy of the web app to make changes in the future.

For more information about the save for deployment option and other options, see Create an Access app package.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!