Does anybody know if there is a limit on how many rows and columns are
allowed in an access table?
255 fields ("columns"), an absurdly high limit (a 60 field table is
*extremely* wide). More critically, there's a hard limit of 2000
characters *actually used* in any single record - that is, you can
define a table with 255 fields of 100 bytes each, and even put a lot
of data into it, but you'll get an error the first time you try to put
ten characters into each field.
There is no explicit limit on the number of rows; you're limited to 2
GByte (1 GByte for A97 and older) in any single .mdb file. In practice
a 10,000,000 row table is getting pretty big.
John W. Vinson[MVP]
