Some of us have worked on systems with tables bigger than that.
A little MySQL system I was working on was up to 3.5 gig compressed after a mere 14 months.
You would struggle big style to do that with access, ten years data unlikely, so you would be mad to start.
Access is good at what it does, there are somethings it doesn't do though because it wasn't designed to do them. If it did it would have bumped into SQL Server and messed up MS's product strategy. That's not a criticism.
I didn't say you could n't stretch the limits of access, there are all sorts of design tricks to get something usable. It would have been a lot easier with a proper DBMS, though.
You can sink in a fence post with a toffee hammer as well, it uses a lot of effort and takes much longer though.
Keep Up with TechRepublic