On Tue, 8 Dec 2009 10:41:02 -0800, Jerry Whittle
wrote:

A 15 mb MDB or ACCDB file is tiny. 150 mb is just starting to work up a
sweat. Access can handle up to 2 GB in one file.

As far as performance, proper data normalization and database design is much
more of a factor.

And you didn't say where the other factories' data is. I hope it's
all local on your network. If it's on a WAN, you'll need to use some
other approaches.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com