Have You Outgrown Ms Access?
It is quite common for companies to out grow Ms Access due to the inherent limitations of the Ms Access “Jet Engine” datastore: slow performance, error messages, unstable application, and data corruption are common signals that you are near, or have exceeded, the built-in limitations of Ms Access. Problems associated with the limitations of Ms Access become all too apparent when you need to scale the application to support more features, more data, and more users. This is when integrating your Ms Access with a SQL Server back-end database is the logical solution.
Ms Access Limitations
Ms Access has several important technical limitations that cannot be overcome with workarounds or special programming techniques. Use the following chart to determine when you can expect to run into problems i.e. slow performance, corrupt database, application crashing, etc:
Integrating Ms Access With SQL Server
Microsoft’s flagship relational database product SQL Server 2012 is designed to handle the data administration and rigorous workload balancing requirements of more demanding business applications. Integrating Ms Access with SQL Server can be challenging or fairly straightforward, depending upon the quality and completeness of your existing Ms Access table structures.
Upsizing Wizard: Garbage In, Garbage Out
The Upsizing Wizard will move Ms Access to SQL Server, but in most cases, the resulting SQL Server database design needs a lot of work, and often we find that designing a SQL Server database from scratch is the more efficient and cost-effective approach. The quality and completeness of your Ms Access application determines whether using the Upsizing Wizard makes sense, or if the Upsizing Wizard will create more work for you to do in the long-run.
The Real Cost Of Staying With Ms Access
Many businesses believe that developing applications in Ms Access is less expensive than alternative such as MSDE or Ms SQL Server. In our experience, developing custom applications with Ms Access can be significantly more expensive than developing business applications with Ms SQL Server and .NET. With Ms Access projects, we tend to spend more time and effort on ‘defensive engineering’ due to limitations, compatibility issues, User Interfaces constraints, and difficulties associated with deploying and controlling Ms Access in a distributed business environment. Furthermore, the Ms Access platform does not scale.
Our engineers spend on average one-third less time developing custom applications on on Ms SQL Server and .NET than with Ms Access. Not only are the results are far better, but the application is more scalable. Since time is money, these applications end up costing our clients LESS, and are MORE beneficial.