Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Important    Access Services 2010 and Access Services 2013 are being removed from the next release of SharePoint. We recommend you do not create new web apps, and migrate your existing apps to an alternative platform, such as Microsoft Power Apps.

You can share Access data with Dataverse, which is a cloud database upon which you can build Power Platform apps, Automate workflows, Virtual Agents, and more for the web, phone, or tablet. For more information, see Get started: Migrate Access data to Dataverse.

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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×