Working around Access' 2GB limit

[TheTominator]

Have you optimized the data types for each field in the big table to reduce the storage requirements? I don't know much about Access but databases like MySQL let you choose what type of integer, string, and so on to constrain the storage size.