I have developed Access databases for years with 300,000+ records that grow to around 50 MB. They are used for activities such as payroll, production planning, environmental reporting and inventory.
Multi-user access over 10 people is not recommended as record locking can be an issue and...