View original (French)

Maximum number of records

TeraoSumo Posted messages 13 Status Member -  
TeraoSumo Posted messages 13 Status Member -
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 answers

  1.
    yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   Ambassador 1 588
     
    Hello, why do you think you are limited to 65,000 records in Access?
    0
    1. TeraoSumo Posted messages 13 Status Member
       
      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
    2. TeraoSumo Posted messages 13 Status Member
       
      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
      1. yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   1 588 > TeraoSumo Posted messages 13 Status Member
         
        correct, as long as we do not reach another limit.
        0
    3. TeraoSumo Posted messages 13 Status Member
       
      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
  2. TeraoSumo Posted messages 13 Status Member
     
    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