Data types for Access web apps

Important Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

When creating tables in Access web apps, you need to select a data type for each column of data. Data types in Access web apps are similar to those in desktop database (.accdb) files, but there are some differences because the data is actually stored in SQL Server (or Microsoft Azure SQL Database, if your web app is on an Office365 site). The following table shows the data types available for Access web apps and what kind of data they’re suitable for. For SQL Server aficionados, we also list the SQL Server data types that they correspond to.