xavier.batlle
Active member
- Local time
- Today, 22:28
- Joined
- Sep 1, 2023
- Messages
- 114
The short answer is: No
So you might be wondering: “What is the maximum number of objects in a database?”
The short answer is: “Nobody knows it!”
I’m going to explain what tests I’ve done and what the results are:
I have developed an easy procedure that is able to create any number of new forms, with or without the property HasModule=True, so I I’ve only tested the maximum number of objects in a database creating new forms, I think the same applies to reports, macros, queries, etc.
These are the databases I’ve created and its number of objects (mostly forms)
- Database 1: 15047 forms with 200 text controls each one and the property HasModule=False (The size of the database is about 1,2 GB)
- Database 2: 73815 forms without controls and the property HasModule=False
- Database 3: 44370 forms with about (20-30) controls each one, and the property HasModule = False
All above tests were stopped by me after 15-20 hours of execution, so you can still add new objects on each one of the above databases.
- Database 4: 5450 forms with 2 text controls and the property Hasmodule=True
This latest test ended up raising an error that it couldn't save more modules, so you can’t create more modules, forms or reports with the property HasModules=True
The more objects have a database the slower it is. Opening some of the databases with thousands of objects may take about 5-10 MINUTES!
To sum up:
So you might be wondering: “What is the maximum number of objects in a database?”
The short answer is: “Nobody knows it!”
I’m going to explain what tests I’ve done and what the results are:
I have developed an easy procedure that is able to create any number of new forms, with or without the property HasModule=True, so I I’ve only tested the maximum number of objects in a database creating new forms, I think the same applies to reports, macros, queries, etc.
These are the databases I’ve created and its number of objects (mostly forms)
- Database 1: 15047 forms with 200 text controls each one and the property HasModule=False (The size of the database is about 1,2 GB)
- Database 2: 73815 forms without controls and the property HasModule=False
- Database 3: 44370 forms with about (20-30) controls each one, and the property HasModule = False
All above tests were stopped by me after 15-20 hours of execution, so you can still add new objects on each one of the above databases.
- Database 4: 5450 forms with 2 text controls and the property Hasmodule=True
This latest test ended up raising an error that it couldn't save more modules, so you can’t create more modules, forms or reports with the property HasModules=True
The more objects have a database the slower it is. Opening some of the databases with thousands of objects may take about 5-10 MINUTES!
To sum up:
- The maximum number of objects = 32768 is not a hard limit, but the more objects have a database the slower it is, and at some point the database is useless because of its slowness
- Form and Report controls are not counted in this Access specification limit.
- Most of forms and reports contains code, so in this case the maximum number of objects with code is about 5400
- Although it is technically possible to work with databases with a large number of objects, it is not recommended at all!
Access Specification issues
Microsoft publishes a list of Access specifications and limits. Most of the information is correct. This article discusses some specification items that are misleading, out-of-date or inaccurate
www.isladogs.co.uk
Last edited: