Max number of rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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..
 
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.
 
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?
Click to expand...

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.
 
Back
Top