Max number of rows

[Guest]

What it the maximum number of row that Access can
handle? I am designing a database that will contain
135,000 row of information? Would this can performance
problems with Access?

 

[Richa Verma]

hi..
yes u can use access as ur database, as there is no limit how many rows u can have. well there should be enough space in ur disk..haha..

 

[Cheryl Fischer]

There is no maximum number of rows. An Access 97 database (MDB) file may
not be larger than 1GB; for Access 2000 and newer the limitation is 2GB.

Specifications are available in the Help file; just type the word
specifications in the Answer Wizard.

 

[John Vinson]

What it the maximum number of row that Access can
handle? I am designing a database that will contain
135,000 row of information? Would this can performance
problems with Access?

There is no explicit number of records in a table; a single .mdb file
is limited to 2 GByte (1 GByte in A97 and older versions).

135,000 rows in the largest table is no problem, provided you have
appropriate indexes and good design. I know of Access applications
with over 10,000,000 rows in the largest table (they take a LOT of
care and feeding though!). I'd start looking at client/server software
when I start pushing a million rows, more because of data integrity
than performance; SQL/Server lets you do live restores to checkpoints,
etc., which Access cannot do.