How good is access table ? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


How good is access table ?

honest_dudehonest_dude Posts: 93Member
I need to store a lots of record and I am just wondering if ms access can accommodate my needs. Can anyone tells how many record access table can hold. I use officeXP.



  • dokken2dokken2 Posts: 532Member
    Around 100,000-200,000 records is a practical
    limit, at that point performance slows down.

    You can run your own tests, build a table
    and fill it with 16 real world records. Then
    run an insert/append query to add records
    to the same table,


    INSERT INTO Table1 ( text, text2 )
    SELECT Table1.text, Table1.text2
    FROM Table1;

    and run it 10-15 times. Each time you will
    double the records and exponentially slow
    down table performance.
Sign In or Register to comment.