How do I set maximum capacity in Access?

How do I change max capacity in Access?

In the Field Properties pane, on the General tab, enter the new field size in the Field Size property. You can enter a value from 1 to 255. This number specifies the maximum number of characters that each value can have. For larger text fields, use the Memo data type (Long Text if using Access 2016).

What is the max size for Access database?

2 gigabytes, minus the space needed for system objects. Note: You can work around this size limitation by linking to tables in other Access databases. You can link to tables in multiple database files, each of which can be as large as 2GB.

How do I increase the size of my Access database?

You can partition your data into one or more additional database files, then create links to the satellite tables from your main application database. Although that strategy could allow you to use more than 2 GB of data stored in Access, it is not a great choice.