The shorter your individual records, the more you can store in a table. I have seen Access applications with millions of records stored in Jet tables. Although each database is limited to 2G, you can link your front end to multiple back ends so the real limit is 2G for any one table rather than all tables in your app. At some point though, you will find that you need to upsize to a real database server to minimize network traffic.
