Possible number of rows in a Access 2002

  • Thread starter Thread starter sverre
  • Start date Start date
S

sverre

Hi

Does anyone know how many rows (or total no of cells) that are possible to
store/import to an Access-2002 table?

best regards
Sverre
 
There are no cells in an Access database.
A record can have up to 255 fields, but if you have a record with that many
fields you are doing something very wrong.
There is no limit to the number of rows. The limit is based on the size of
the mdb which can be up to 2gig.
 
Hi

Does anyone know how many rows (or total no of cells) that are possible to
store/import to an Access-2002 table?

best regards
Sverre
Click to expand...

There is no explicit limit on the number of rows; I know of working tables
with 20,000,000 rows in a table, though that's a lot bigger than I'd
recommend. There are no "cells" in a database; the limit of Fields in a table
is 255 (absurdly huge for any properly normalized table structure), and there
is a limit of 2000 characters actually USED in a single record. That is, you
can have a table with 20 fields each defined as 255 characters, but you'll get
an error if you enter a record with all of them filled with over 100
characters.

The limit on the size of an entire database is two gigabytes, including all
the tables, forms, reports, system tables and overhead.

Search for Help on "Specifications" for all the limits.
 
There are also limits to how many characters (total) that can be stored in
one "row". Check Access HELP for "specifications".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi John,

If I uppgrade to Access 2007 - what limit do I have on the mdb then?

I assume that the 07-version is much faster than 2002-version aswell?

Best regards
Sverker
 
sverre said:
Hi John,

If I uppgrade to Access 2007 - what limit do I have on the mdb then?
Click to expand...

The same.
I assume that the 07-version is much faster than 2002-version aswell?
Click to expand...

Why on earth woudl you assume that? No version of Access (or most any other
Microsoft program) has ever been faster than previous ones.

MS assumes that in the three years or so between releases that PC hardware
has advanced to the point that the new version can be slower on the same
hardware, but the advances in new hardware make up the difference. In side
by side comparisons on the same hardware having the new version run about
the same is the best you can reasonably hope for.
 
Back
Top