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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.