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.

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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×