Size limitation of an Access database

Question

Describe the size limitation of an Access database.

Answer 1

Size limitation does not be relevant to the number of records in a table within the database. Forms, macros, reports, and the modules also contribute to the database size, however is rather minimal in comparison to the tables consisting of the records. It is recommended that if large amounts of the data will be managed or constantly deleted and new data imported, put your tables in the other database and link tables back into the main database. Utilities for database compression and repair will run much more rapidly. In the Access 2.0 databases byte size limitation is 1 gigabyte. Generally, use of the 1gb rule and suggestions here to manage the performance of database.