J jj Feb 25, 2005 #1 Is there a maximum data size(MB) an Access table is supposed to hold? Or a maximum number or rows? concerned jj
Is there a maximum data size(MB) an Access table is supposed to hold? Or a maximum number or rows? concerned jj
G Guest Feb 25, 2005 #2 For a particular table? Not that I know of. Number of rows? Largely depends on the data type for the primary key. For a database, however, Access begins to really puke around 50MB in most instances. You can get much larger than that, but it is not efficient. --- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA *************************** Think Outside the Box! ***************************
For a particular table? Not that I know of. Number of rows? Largely depends on the data type for the primary key. For a database, however, Access begins to really puke around 50MB in most instances. You can get much larger than that, but it is not efficient. --- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA *************************** Think Outside the Box! ***************************
S Sahil Malik Feb 25, 2005 #3 How large are you going? In my experience, the "official limit" if any, is immaterial because access is terrible after a few tens of mb's. Wait till you hit a gig, that gets almost entertaining. - Sahil Malik http://codebetter.com/blogs/sahil.malik/
How large are you going? In my experience, the "official limit" if any, is immaterial because access is terrible after a few tens of mb's. Wait till you hit a gig, that gets almost entertaining. - Sahil Malik http://codebetter.com/blogs/sahil.malik/
