Hi
Microsoft Access (2000) database table specifications
Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048. The actual number may be less because of tables
open internally by Microsoft Access.
Table size 1 gigabyte
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the
user interface;
1 gigabyte when entering data programmatically.
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields)
2,000
Number of characters in a field property setting 255
As you see, no direct limitations for number of rows - it equals 1
Gb/RowSize, where RowSize depends on your table design. (Memo fields and
(when designed properly) OLE object fields contain only links.)
--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets
"Allan Bach" (DONOTSPAM) wrote in message
...
Is it possible to have more than 65000 entries in Access?
kr.
Allan
"Arvi Laanemets" skrev:
Hi
"Allan Bach" (DONOTSPAM) wrote in message
...
Hi
In Excel the maximum number of rows i can get is 65536. Is it possible
to
extend this so i can get about 67000 rows?
Not on same sheet!
Your options:
Delete some abundant rows, when you have them;
Distribute your data to several worksheets;
Redesign your worksheet, so that the number of needed rows decreases (in
case it's possible to collect the info from several rows to one single
row);
Switch to Access or to any other database application;
Swithc to QuattroPro.
--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets
Kind regards
Allan Bach
|