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.

You can lock a table in an Access web app to keep data from being edited or deleted. Locking tables helps when you want to include sample data in your web app that you provide to users of the app. Locking is especially useful when you plan to distribute an Access app in your App Catalog or in the SharePoint Store. After you lock a table, you can upgrade the web app later without overwriting the data that users have stored in their instances of your web app.

Note: The option to lock tables is available only for Access web apps that are on Microsoft 365 or SharePoint Online sites. To see the Lock option, you also need to have Access 2013 with Office 2013 Service Pack 1 (SP1) or higher installed on your computer or device.

  1. Open the web app in Access and select the table you want to lock from the Table Selector in the left pane.

  2. Click Settings/Actions > Lock.

    Lock command on the Settings menu

    The Lock icon appears next to the name of the table.

    Locked icon appearing on a locked table in Access

    Tip: To unlock a table, follow the same steps and click Unlock.

What happens when you lock a table in an Access web app?

Data in locked tables is read-only for users, which means no one can edit it from either Access or from the browser. If you need to add data to a locked table, you need to unlock it first, and then you can lock the table later.

When users upgrade an app by installing a new version from the App Catalog or the SharePoint Store, new data in any locked table overwrites data in the app. This should be okay, since users can store data only in unlocked tables and data from unlocked tables is not included in app packages for deployment.

An app author can use an On Deploy Data Macro to move the data from a locked table to another table when the upgrade is deployed. This preserves the end user’s data, and appends it with the app author’s data.

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!

×