How many lines can Access handle?

  • Thread starter Thread starter DJ
  • Start date Start date
D

DJ

I am trying to find out how many lines Access can handle.
Excel only handles 65,000, but I have 10 times that many.
 
There is no limit to the number of records an Access table can hold, as long
as the size of the database itself (MDB file) does not exceed 1 GB for an
Access 97 database or 2 GB for an Access 2000 (or newer version) database.
 
I am trying to find out how many lines Access can handle.
Excel only handles 65,000, but I have 10 times that many.
Click to expand...

A 20,000,000 row Table is getting pretty large. 650,000 should be no
problem.

Do note that a Spreadsheet and a Database are TWO VERY DIFFERENT
OBJECTS. Treating Access as a "big version of Excel" will get you into
some *real* design problems!
 
Back
Top