max number of rows in a table

[Anne]

Hi, Expert,

I am going to design a new ACCESS application. I do not know what is the max
number of rows that a table can have. Search for web did not answer my
question.

 

[Lynn Trapp]

There is no maximum number of rows for an Access table. There is a maximum
number of characters per row (2000) and a maximum file size (2GB).

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Tim Ferguson]

I do not know what is the max
number of rows that a table can have. Search for web did not answer my
question.

Try searching the help files, under Access specifications. Although it's
not explicit, there is no limit to numbers of rows, except that the table
must fit within a mdb file, which is limited to 2GB.

HTH


Tim F