My office uses ColdFusion/Access to generate pages. There are thousands of pages, and some tables are in range of 60MB. Now they are planning to add more to it and is MS Access reliable to scale it up or we should move it to other DB system
Is MS Access Scalable?
No. You should avoid MS Access as its mainly for home users and not meant for commercial use anyway and when you have 100s of queries simultaneously it would be a problem. Try MySQL instead