Blog
Business IT News &
Technology Information
The Case for Microsoft Access and SQL Azure
Craig Yellick, VP Business Solutions
What is Microsoft Access?
Many organizations have a love-hate relationship with Microsoft Access. They love the rapid application development model and the powerful data-driven solutions constructed so cost effectively, but hate the local file server-only, desktop database engine. This makes Access applications of very limited effectiveness for distributed users who need access outside of the main office where the database lives.
Migrating the Access database to SQL Server has long been the best route to a better, faster, more secure storage engine but that does not solve the issue of remote access. Nobody wants to expose an internal SQL Server to the public Internet, especially just to support a minor application. And the licensing can get frightfully expensive as well.
Experience The Power of Access or Azure With Software Development Services
With Blue Net’s software development services, it’s easy to experience the power of Microsoft Access or Azure.
Leveraging SQL Azure
When our customers are faced with this challenge, our go-to solution is SQL Azure: the secure SQL database in the cloud that’s priced based on resource consumption, not user counts. If you barely use it, it barely costs anything. It’s nearly infinitely scalable, both up and down, to accommodate patterns of heavy use interleaved with more idle periods – you pay only for what you actually use. Security is enhanced by a powerful built-in firewall that can be restricted down to individual IP addresses.”
Users appreciate the familiar look-and-feel and usability of the Access application because nothing changes from the front-end perspective. Data entry forms, queries, reports, custom programming – all continue to use the familiar Access development environment and programming APIs. The only difference is that the data is available anywhere there’s an Internet connection.
Work With the Best Office 365 Consultant in Minneapolis
Call Blue Net today at 952-925-2583 for a demonstration and discussion of your options. It’s never been a better time to leverage Microsoft Access and SQL Azure.