View original (French)

Maximum number of records

TeraoSumo Posted messages 13 Status Membre -  
TeraoSumo Posted messages 13 Status Membre -
Hello,
I have an ACCESS 2003/2007 database in which it's possible to create 60 or 65,000 records (lines), and I'm soon reaching saturation, but I would like to continue adding records.
I noticed that in EXCEL files that were at their limits, the number of rows went up to over 1,000,000.
However, in Access help, it is impossible to find the answer. The only thing mentioned is "maximum size 2 GB."
Do you have an answer?
Thank you and have a good day.

Configuration: Windows / Edge 17.17134

2 réponses

Réponse 1 / 2
yg_be Posted messages 23437 Registration date   Status Contributeur Last intervention   Ambassadeur 1 588
 
Hello, why do you think you are limited to 65,000 records in Access?
0
TeraoSumo Posted messages 13 Status Membre
 
Good evening, it seems to me that this is what I read a long time ago in Access 2003 when I started.
How can I find out the limit in Office 365?
Thank you
0
yg_be Posted messages 23437 Registration date   Status Contributeur Last intervention   1 588 > TeraoSumo Posted messages 13 Status Membre
 
I think you misread or misremembered.
Suggested reading: https://support.microsoft.com/en-us/office/access-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c?ui=en-us&rs=en-us&ad=en
0
TeraoSumo Posted messages 13 Status Membre
 
Good evening and thank you. But there is still no answer for the number of records, only the table size of 2GB.

So there is no limit!!? Correct?
0
yg_be Posted messages 23437 Registration date   Status Contributeur Last intervention   1 588 > TeraoSumo Posted messages 13 Status Membre
 
correct, as long as we do not reach another limit.
0
TeraoSumo Posted messages 13 Status Membre
 
Thank you, I have therefore split my database of 52,000 records for nothing.
I will try to reconstruct it.
Have a good day.
0
Réponse 2 / 2
TeraoSumo Posted messages 13 Status Membre
 
Another question.
In the same database, I have a "short text" field of 6 characters.
In Access 2003, if I enter for example: 2000, then 2001 in the next field, and I press "down arrow", the subsequent fields are automatically numbered 2002, 2003, etc.
Not in Access 2016.
0