Maximum number of rows in one table of Access 2000

Discussion in 'Microsoft Access External Data' started by Manish Patel, Jan 28, 2004.

  1. Manish Patel

    Manish Patel Guest

    Does anyone know what is the maximum number of rows that a
    table in MS-Access database can hold? We are on Access
    2000 and we need a table to contain 95000 rows.

    However, we get an error when we try to upload more than
    62249 rows in one table.

    Any help is appreicated.

    Regards,
    Manish Patel
     
    Manish Patel, Jan 28, 2004
    #1
    1. Advertisements

  2. Manish Patel

    John Nurick Guest

    Hi Manish,

    There's no specific limit, and tables with millions of rows are not
    uncommon. There is however a limit of 2GB on the size of an Access 2000
    (or later) mdb file.

    How are you "uploading" the data and what error are you getting?

    On Tue, 27 Jan 2004 20:57:12 -0800, "Manish Patel"
    <> wrote:

    >
    >Does anyone know what is the maximum number of rows that a
    >table in MS-Access database can hold? We are on Access
    >2000 and we need a table to contain 95000 rows.
    >
    >However, we get an error when we try to upload more than
    >62249 rows in one table.
    >
    >Any help is appreicated.
    >
    >Regards,
    >Manish Patel


    --
    John Nurick [Microsoft Access MVP]

    Please respond in the newgroup and not by email.
     
    John Nurick, Jan 28, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Yuet

    Import - Maximum number of Fields

    Yuet, Sep 5, 2003, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    241
    Kevin3NF
    Sep 5, 2003
  2. deltadoll

    Is there a way to merge one access table into another access table?

    deltadoll, Mar 9, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    363
    John Nurick
    Mar 9, 2004
  3. Shirley

    maximum number of records in recording

    Shirley, Mar 26, 2004, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    203
    Ronald W. Roberts
    Mar 27, 2004
  4. Richard

    OLE - Is there a maximum number of excel-files

    Richard, Sep 7, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    226
    John Nurick
    Sep 7, 2004
  5. Guest

    maximum number of records that can be copied to clipboard

    Guest, Apr 28, 2005, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    569
    John Nurick
    Apr 28, 2005
  6. Guest

    what is the maximum number of rows when exporting query to excel

    Guest, Jul 18, 2005, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    853
    Ken Snell [MVP]
    Jul 19, 2005
  7. Guest

    Importing Excel into Access table creates blank rows to table?

    Guest, Jan 11, 2006, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    1,202
    Guest
    Jan 11, 2006
  8. Linkerbink

    Access counts blank rows in Excel rows as records in linked table

    Linkerbink, Nov 14, 2009, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    2,837
    Ken Snell
    Nov 14, 2009
Loading...