Access 2003

[J Speed]

Does anyone know what the maximum number of records an Access Table can hold
(NOT SQL)?

 

[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

 

[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]

 

[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

 

[K O R E A]

J Speed ÀÌ(°¡) ¸Þ½ÃÁö¿¡¼­ ÀÛ¼ºÇÏ¿´½À´Ï´Ù...

 

[K O R E A]

J Speed ÀÌ(°¡) ¸Þ½ÃÁö¿¡¼­ ÀÛ¼ºÇÏ¿´½À´Ï´Ù...