Access Maximum Table Size

[Roy]

Hi guys,
I would like to know the maximum table size of MS Access.
Thanks you for kind attention!!

Roy

 

[Mark]

Access 97 1GB
Access 2000 and up 2GB.

 

[Kevin3NF]

Those limits are for the database, as well as individual tables, although I
would hate to see a 2GB Access table...
--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[tina]

fyi, if you open Access Help and search on "specifications", you find not
only table size but more than you ever wanted to know about all the
specifications for a database and its' objects.