search
HomeDatabaseMysql TutorialWhat is the maximum storage space of an Access database?

Database
Properties                                                                                                                                                 ’s ’s ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐                                                                                                       to
ObjectRequired space. The number of objects in the database 32,768
module (including the window and report of the "inner module" attribute "yes") 1,000
The number of characters in the name of the object 64
Number of characters 14
The number of characters in the user name or group name 20
The number of concurrent users                           255


Table
Attribute Maximum Value
Table The number of characters in the name 64
The number of characters in the field name 64
The number of fields in the table 255
The number of open tables 2048; the actual number of open tables may be less, because Microsoft Access also opens some internal tables.
The size of the table 2G bytes minus the space required for system objects
The number of characters in the "Text" field 255
The number of characters in the "Remarks" field entered through the user interface is 65,535; with
ProgrammingThe character storage is 1G bytes when input. The size of the "OLE object" field 1G bytes

Indices in the tableNumber 32 Number of fields in the index 10
Number of characters in the validity message 255
The number of characters in the validity rule 2,048
The number of characters in the table or field description 255
The number of characters in the record (except the "Remarks" field and the "OLE Object" field) 2,000
Field The number of characters set in the attribute is 255


Query
Attribute Maximum value
The number of implemented relationships is 32 for each table minus Number of indexes for fields or field combinations in the table that are not included in the relationship
Number of tables in the query 32
Number of fields in the record set 255
Record set size 1G bytes
Sorting Limit 255 characters (one or more fields)
The number of levels of nested queries 50
The number of characters in a cell of the query design grid 1,024
The number of parameter characters for parameter queries 255
The number of AND in the Where or HAVING clause is 99
The number of characters in the SQL statement is approximately 64,000


Forms and reports
Attributes are the best ?br />Number of characters in label 2,048
Number of characters in text box 65,535
Form or report width 22 inches (55.87 cm)
Section height 22 inches (55.87 cm)
Height of all sections plus section headers (in "Design"
View) 200 inches (508 cm) Maximum number of nesting levels for a form or report 7
Can be in a report The number of fields or
expressions used as the basis for sorting or grouping 10 The number of headers and footers in the report is 1 pair of report header/report footer, 1 pair of page header/page footer, 10 pairs of group header/group footer
The number of printed pages of the report 65,536
The number of controls that can be added to the form or report and sections 754
The number of characters in the SQL statement as the "record source" or "row source" attribute of the form, report, or control (Applicable to .mdb and .adp) 32,750

Macro

Attribute Maximum value
The number of operations in the macro 999
The number of characters in the condition Number 255
The number of characters in the remark 255
The number of characters in the operation parameter 255



Microsoft Access Project Specifications
Access Project

Attribute Maximum value
The number of objects in a Microsoft Access project (.adp) 32,768
Modules (including forms and reports with the "Contains Modules" property set to "Yes") 1,000
The number of characters in the object name 64
The number of indexes in the table 250 (Microsoft SQL Server 6.5)
1024 (Microsoft SQL Server 7.0 and 2000)

[Related recommendations]

1. Mysql free video tutorial

2. Teach you how to start and stop the Mysql service Part 2

3. Teach you how to start and stop one of the Mysql services

4. Example tutorial for processing special sql statements in mysql

5. Delete table Detailed explanation of how to write SQL statements in different databases

The above is the detailed content of What is the maximum storage space of an Access database?. For more information, please follow other related articles on the PHP Chinese website!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
How do you alter a table in MySQL using the ALTER TABLE statement?How do you alter a table in MySQL using the ALTER TABLE statement?Mar 19, 2025 pm 03:51 PM

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

How do I configure SSL/TLS encryption for MySQL connections?How do I configure SSL/TLS encryption for MySQL connections?Mar 18, 2025 pm 12:01 PM

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

How do you handle large datasets in MySQL?How do you handle large datasets in MySQL?Mar 21, 2025 pm 12:15 PM

Article discusses strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.

What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?Mar 21, 2025 pm 06:28 PM

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

How do you drop a table in MySQL using the DROP TABLE statement?How do you drop a table in MySQL using the DROP TABLE statement?Mar 19, 2025 pm 03:52 PM

The article discusses dropping tables in MySQL using the DROP TABLE statement, emphasizing precautions and risks. It highlights that the action is irreversible without backups, detailing recovery methods and potential production environment hazards.

How do you represent relationships using foreign keys?How do you represent relationships using foreign keys?Mar 19, 2025 pm 03:48 PM

Article discusses using foreign keys to represent relationships in databases, focusing on best practices, data integrity, and common pitfalls to avoid.

How do you create indexes on JSON columns?How do you create indexes on JSON columns?Mar 21, 2025 pm 12:13 PM

The article discusses creating indexes on JSON columns in various databases like PostgreSQL, MySQL, and MongoDB to enhance query performance. It explains the syntax and benefits of indexing specific JSON paths, and lists supported database systems.

How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?Mar 18, 2025 pm 12:00 PM

Article discusses securing MySQL against SQL injection and brute-force attacks using prepared statements, input validation, and strong password policies.(159 characters)

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Tools

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.