J J Speed Feb 5, 2005 #1 Does anyone know what the maximum number of records an Access Table can hold (NOT SQL)?
J JudithJubilee Feb 5, 2005 #2 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
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
J John Vinson Feb 5, 2005 #3 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. Click to expand... That's actually 2 *giga*bytes - 2,000,000 kilobytes. John W. Vinson[MVP]
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. Click to expand... That's actually 2 *giga*bytes - 2,000,000 kilobytes. John W. Vinson[MVP]
J JudithJubilee Feb 5, 2005 #4 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
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
