Is there a software package that I can buy or free that can expand the access
database size to more that 2 GB. Thanks in advance.
SQL/Server (many terabytes), MySQL, Ingres, DB/2, Visual FoxPro, many
others.
You'll need to store your data outside of Access.
If you're hitting the 2 GByte limit because you're storing graphical
images, be aware that Access is EXCEEDINGLY inefficient in this
regard. You may want to consider storing the images in separate .jpg
or other graphics files externally, and just storing a path and
filename; or storing the images in a BLOB object rather than telling
Access that it's image data. See
http://www.mvps.org/access/forms/frm0030.htm
for some useful links.
John W. Vinson[MVP]
