Posted on: Friday, March 7th, 2014
Most Microsoft Access databases were created by beginners or power users who had limited experience or knowledge to create professional applications. These applications were built up over time, incorporating new features and data models, but with little consideration given to either performance or scalability. Many became business critical but were typically poorly designed, complex to support, difficult to develop further, didn’t reliably support more than a few concurrent users, and placed a great burden on network infrastructures.
The evolution of these databases into important or business critical applications requires such companies to address a myriad of key business and technical drivers. ‘Business and Technical Drivers behind Access to SQL Conversions‘ explains, at a high level, the typical corporate profiles and key drivers found in many Access database environments.