Is there a limit to the size of an Access database?

What is the size limit of Microsoft Access database?

General. 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.

What is the maximum size of an Access 2010 database?

General. Total size for an Access 2010 database (. accdb), including all database objects and data: 2 gigabytes, minus the space needed for system objects. You can work around this size limitation by linking to tables in other Access databases.

How do I increase the size of my Access database?

Open MS Access database file. Go to the Database Tools Menu, click on Compact and Repair Database. (This may take some time, which depends on the database file size). As you add, update the data, and change its design, a database file becomes larger.

Can MS Access handle millions of records?

Access is well able to handle a million or 5 million records. SQL Server goes well into BILLIONS of records.