Maximum database size, and table size !

[Pierre Fournier]

What is the maximum size of a database with access 2002, permetting to avoid
the error code 3036, "the database have rearch is maximum size" ?

 

[Kevin3NF]

2GB. Table is not limited by number of rows, other than db size and hardware
size...

See specifications in Access help

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[John Vinson]

What is the maximum size of a database with access 2002, permetting to avoid
the error code 3036, "the database have rearch is maximum size" ?

It's still 2GByte (2048 Mbyte) for any single .mdb file. Regular
compaction is essential for decent performance; a split database
(tables in one shared database, forms, reports, queries etc. in
individual frontends) is needed if it's a shared database. If you're
storing graphical images... don't! Access is TERRIBLE at handling
them; store the images in external files and store links to them in
your database.


John W. Vinson[MVP]