• Maximum no. of records (Access 2000)

    Author
    Topic
    #391301

    (Edited by HansV on 31-Jul-03 14:48. Changed app to Access instead of Outlook)

    Does anyone know if MS Access tables have a maximum limit of the number of records before it becomes unstable?

    Viewing 0 reply threads
    Author
    Replies
    • #698529

      An Access database can become up to 2 Gigabyte in size, but it will probably develop problems well before that. Apart from that, there is no theoretical limit to the number of records. I have worked with tables of about a million records without problems, but I don’t know how much further you can go.

      • #698534

        Thank you…Susan

        • #698600

          Susan,

          I am currently running a database that has two tables with 4 million or more records without any problems over the last year.

          • #698614

            I am currently running a database that has two tables with 4 million or more records

            That’s quite a contact list you are running there, Gary! wink

            • #698649

              Nope – No contacts – Just a lot of budgeting and earned value data from MPM spanning 1998 through 2015.

    Viewing 0 reply threads
    Reply To: Reply #698529 in Maximum no. of records (Access 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




    Cancel