row and column limit

[Will Fleenor]

It there any limit to the number or row or number of columns you can have in
a Microsoft Access 2003 table?

I realize that there are memory limitations, and physical file size
limitiations (depending on the OS). However what I would like to know is if
there is a specific number limitation to rows and columns. If not what is
the "practical limitation?" (i.e. the point at which Access just can not
bear the load)

I relaize that this is generally not an issue, but it is a question I am
often ask?

Thanks, Will

 

[Allen Browne]

The practical limit is that one MDB file can be only 2 gigabytes in size
(1GB for Access 97 and earlier.)

If you foresee millions of records in some tables before you begin, you
might want to consider a larger database.

 

[Douglas J. Steele]

There is no row limit per se. As Allen mentioned, an MDB file cannot exceed
2 Gb (1 Gb for Access 97 and earlier). In addition to that, a table cannot
span multiple MDB files, and a row cannot exceed 2000 characters.

There is a 255 column limit, but that's at least 5 times larger than should
be required for properly normalized tables.