Data types for Access web apps
Applies To
Access for Microsoft 365 Access 2019 Access 2016 Access 2013
| 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. |
|---|
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. 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.
| Data type | Subtype property setting | Description | Corresponding SQL Server data type |
|---|---|---|---|
| AutoNumber | n/a | Unique value generated by Access for each new record. | int |
| Short Text | n/a | Alphanumeric data, 1 to 4000 characters (default character limit is 255). | nvarchar with length from 1 to 4000 |
| Long Text | n/a | Alphanumeric data, up to 2^30-1 bytes. | nvarchar(max) |
| Number | Whole Number (no decimal places) | Numeric data. | int |
| Number | Floating-point number (variable decimal places) | Numeric data. | double |
| Number | Fixed-point number (6 decimal places) | Numeric data. | decimal(28,6) |
| Date/Time | Date | Dates. | date |
| Date/Time | Time | Times. | time(3) |
| Date/Time | Date with Time | Dates and times. | datetime2(3) |
| Currency | n/a | Monetary data. | decimal(28,6) |
| Yes/No | n/a | Boolean (yes/no) data. | bit (default is false) |
| Hyperlink | n/a | A link address to a document or file on the Internet or on an intranet | nvarchar(max) |
| Image | n/a | Picture data. | Binary Image data varbinary(max), 2^31-1 bytes |
| Calculated | n/a | Results of an expression you create using data from one or more fields in the table. | Depends on the results of the expression. |
| Lookup | Value List | Uses the contents a value list to validate the contents of the field. | nvarchar(220) |
| Lookup | Other table or query | Uses the ID field of another table or query to validate the contents of the field. | int |
Learn more about SQL Server Data Types.