Is it of much practical significance that 2 GB is max size of Access Database?  Is this of much real world concern? Have you seen this occur?

---

Reply from Richard Rost:

It's not a big deal. 2 GB is the max size of any ONE database file, but (a) I've got some pretty big databases that are well under that size, and (b) you can always split your database and link to those tables. My main 599CD customer database, for example, consists of 3 parts... a "front end" database which has the forms, reports, queries, and VBA code which is only about 100 MB; and two databases that contain all of the tables (one for customers and orders, and a second just for my email addresses and customer service history). There is no limit to the number of external databases you can LINK to, so really there is no PRACTICAL limit to the size of your database.