S Squibbly May 24, 2004 #1 how big can a database go up to, i have 1 that is currently 40Mb, would i need to make a new database soon??
how big can a database go up to, i have 1 that is currently 40Mb, would i need to make a new database soon??
L Lynn Trapp May 24, 2004 #2 You have a long way to go yet. The maximum size of an Access 2000, or later, file is 2GB (for A97 and earlier it's 1GB).
You have a long way to go yet. The maximum size of an Access 2000, or later, file is 2GB (for A97 and earlier it's 1GB).
J John Vinson May 24, 2004 #3 how big can a database go up to, i have 1 that is currently 40Mb, would i need to make a new database soon?? Click to expand... Are you regularly Compacting (tools... database utilities... compact and repair)? If so, you can store fifty times as much data as you currently have before you hit the 2GByte (2048 MByte) size limit. If not... do so; and you'll be able to store even more.
how big can a database go up to, i have 1 that is currently 40Mb, would i need to make a new database soon?? Click to expand... Are you regularly Compacting (tools... database utilities... compact and repair)? If so, you can store fifty times as much data as you currently have before you hit the 2GByte (2048 MByte) size limit. If not... do so; and you'll be able to store even more.
