Access specifications

This article has information about the limits of Microsoft Access database files and objects. In most cases when a database exceeds the following limits it might be an indication of a design issue. Using the information in this article and a careful examination of your database design might help you locate what needs to be corrected for successful implementation. For example, importing data directly from Microsoft Excel into Access without normalization can result in creation of additional fields (columns). If you’d like information about designing databases or normalization, take a look at the resources in the Additional information section.