At what file size does an mdb stop working?

[Patrick Jackman]

I know that Access 2000 - 2007 has a 2GB file size limit which would be
2,147,484,648 bytes. But is there a lower limit at which the file becomes
unworkable?

What happens when you hit the limit?

Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-
Patrick Jackman
Vancouver, BC
604-874-5774

[John W. Vinson]

The database should continue to work (perhaps with slower performance) up
until it hits the limit. Failure is abrupt, not gradual: when the database
exceeds 2Gbyte you'll get (one of a variety of) error messages.

If you in fact have 2GByte of actual data, you should certainly be using a
more scalable database engine such as SQL/Server or another client/server
application. If the database is bloating (for any of a lot of reasons) you can
use Compact to recover waste space... and find out why it's bloating and fix
it!!! If you're storing a lot of pictures or documents or other large binary
objects in the database, consider storing Hyperlinks or just the path and
filename of external files instead.

--

John W. Vinson [MVP]