Possible number of rows in a Access 2002

[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

 

[Klatuu]

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.

 

[John W. Vinson]

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

 

[Jeff Boyce]

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

 

[sverre]

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