If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Possible number of rows in a Access 2002
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 |
#2
|
|||
|
|||
Possible number of rows in a Access 2002
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. -- Dave Hargis, Microsoft Access MVP "sverre" wrote: 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 |
#3
|
|||
|
|||
Possible number of rows in a Access 2002
On Fri, 11 Apr 2008 06:53:01 -0700, sverre
wrote: 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. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Possible number of rows in a Access 2002
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" wrote in message ... 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 |
#5
|
|||
|
|||
Possible number of rows in a Access 2002
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 "John W. Vinson" wrote: On Fri, 11 Apr 2008 06:53:01 -0700, sverre wrote: 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. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Possible number of rows in a Access 2002
sverre wrote:
Hi John, If I uppgrade to Access 2007 - what limit do I have on the mdb then? The same. I assume that the 07-version is much faster than 2002-version aswell? 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|