Microsoft Access 2010 Bible

Part VI: Access as an Enterprise Platform

1236

FIGURE 38.10

SQL Server field data types in an ADP database are considerably different from the way they are in Access.

The data types available in Access are described in Table 38.1.

TABLE 38.1

The Details of Access Data Types

Data Type Used to Store Limitations/Restrictions

Text Alphanumeric

data (text and

numbers)

Stores up to 255 characters.

Memo Alphanumeric

data (text and

numbers)

Stores up to 2GB of data (the size limit for all Access databases), if you

fill the field programmatically. Remember that adding 2GB of data

causes your database to operate slowly.

If you enter data manually, you can enter and view a maximum of

65,535 characters in the table field and in any controls that you bind to

the field.

When you create databases in the Access file format, Memo fields also

support rich-text editing.