max no. of records

[Yatin]

Hello,

Does anyone know what the maximum number of records a
table could hold... until a conversion to SQL e.g. is
needed.

Thanks

 

[Kevin @ 3NF]

Max fields per table is 255.

See specifications in Access help

 

[tina]

-----Original Message-----
Max fields per table is 255.

See specifications in Access help

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm






.
oops - my bad! the Microsoft Access database table

specifications also says that maximum table size is 1 GB
and maximum number of characters per record is 2,000
(excluding memo/OLE object fields).