F
FatboySim79
I believe Access 2007 can have a maximum of 255 columns but whats the maximum
number of rows Access 2007 can take?
number of rows Access 2007 can take?
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.
D
Douglas J. Steele
As has been the case with every version of Access, there is no limit in
terms of maximum number of rows. The only limit is that a table must be in a
single MDB (or ACCDB) file, and that the size of the file cannot exceed 2
Gb.
terms of maximum number of rows. The only limit is that a table must be in a
single MDB (or ACCDB) file, and that the size of the file cannot exceed 2
Gb.
J
John W. Vinson
I believe Access 2007 can have a maximum of 255 columns but whats the maximum
number of rows Access 2007 can take?
There's no limit other than the 2GByte size of the entire database file. In
practice I've routinely used tables with 100000-500000 rows, occasionally used
1 to 2 million rows, and I know of datatabases with 20,000,000 rows in the
largest table.
btw any table with anything NEAR 255 fields is almost certainly non-normalized
and in need of restructuring.
D
David W. Fenton
btw any table with anything NEAR 255 fields is almost certainly
non-normalized and in need of restructuring.
I'd say any table with 100 fields is 99.99% likely to be
denormalized.
Anything over 50 seems suspect to me.