Access limits

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I have been requested to import a lot of text files into
Access. The number of rows (5 columns) would be in the
millions. Anyone have a guess at the practical max number
of rows I can put in a table?
Thanks,
Nick
 
It's not the number of records, its the size of the records. For the limits,
see this link. It is for Access 97 and has a link that will take you to the
same information for Access 2002. It can also be found in the help file if
you search on the word "specifications".
 
I have been requested to import a lot of text files into
Access. The number of rows (5 columns) would be in the
millions. Anyone have a guess at the practical max number
of rows I can put in a table?
Thanks,
Nick
Click to expand...

You're limited to 2 GByte (2048 MByte) in any single .mdb file. The
largest production Access database of which I am aware has 50,000,000
rows in the largest table. A few million rows in a well-designed
database should be quite practical.
 
Back
Top