Working around Access' 2GB limit

[Greg the dogsitter]

TheTominator Wrote:
-------------------------------------------------------
> 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.

Yup.

I think it's the indexes that are killing me. Am checking, now...