J
J Speed
Does anyone know what the maximum number of records an Access Table can hold
(NOT SQL)?
(NOT SQL)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JudithJubilee
Hello there,
There is no actual maximum records. It all about the size
of the whole table. In Access 2000 it was 1 kilobyte in
2003 I believe it's now 2.
If you type in "Specifications" or "Limits" into the Help
it will give you a list of every limit, eg. Characters in
fields, etc.
Hope this helps
Judith
There is no actual maximum records. It all about the size
of the whole table. In Access 2000 it was 1 kilobyte in
2003 I believe it's now 2.
If you type in "Specifications" or "Limits" into the Help
it will give you a list of every limit, eg. Characters in
fields, etc.
Hope this helps
Judith
J
John Vinson
Hello there,
There is no actual maximum records. It all about the size
of the whole table. In Access 2000 it was 1 kilobyte in
2003 I believe it's now 2.
That's actually 2 *giga*bytes - 2,000,000 kilobytes.
John W. Vinson[MVP]
J
JudithJubilee
Hello John,
Opps! Sorry about that. It's always the one you didn't
read back isn't it? We can't have false info out there!!
Cheers
Judith
Opps! Sorry about that. It's always the one you didn't
read back isn't it? We can't have false info out there!!
Cheers
Judith
K
K O R E A
J Speed ÀÌ(°¡) ¸Þ½ÃÁö¿¡¼ ÀÛ¼ºÇÏ¿´½À´Ï´Ù...
K
K O R E A
J Speed ÀÌ(°¡) ¸Þ½ÃÁö¿¡¼ ÀÛ¼ºÇÏ¿´½À´Ï´Ù...