Can MS Access handle 3 million records in a single database? How big do you guys think the system should be? Need help ASAP.
Not too sure, but if you're going to have 3 million records i wouldn't recommend access. If you can you should use a more powerful database program like Oracle.
No, it won't work the way that you want it to. You need a "real" database for that.