Turing's Man Blog
- Last Updated on Saturday, 15 June 2013 21:07
- Published on Thursday, 13 June 2013 21:53
- Written by Pawel Wawrzyniak
- Hits: 17600
… However, before the actual comparison, let me tell you what I don't like about MS Access: the fact that so many developers don't know MS Access and cannot understand where it can be applied professionally with success. Maybe – this is a challenge for Microsoft's marketing department? Who knows? The result is that all those, not very experienced, developers are making too much "bad press" around MS Access as a product by claims like: "it's not stable", "it's slow", "it's buggy", "it's a toy", "it's for amateurs" or "it's too simple", "it's not ready for enterprise deployment"… Come on? What's the problem?
Engineers don't value the tools – a hammer is great, same like a screwdriver and a welding machine. The key is to understand the purpose of a tool and our target. Hence, the requirements behind an actual application. So, I'm always embarrassed reading all these statements on professional forums, like: "don't' use MS Access, go with MySQL" (well – it's like: "don't' drive your car, go with a plane") or "always do it in C#" ("eat meat only"). Mostly, these recommendations are pointless and rarely funny.
In my personal opinion MS Access is a great tool – not only when it comes to data manipulation (taken from multiple data sources), but also when we have to rapidly (in an old-good RAD fashion) prototype or develop a database application. It just has it all: ODBC support, SQL, VBA, reports, forms, queries, Sharepoint integration etc. We just have to learn the basics of MS Access and understand where it can be placed among other available database development technologies.
To help us learn about other opportunities when it comes to database development, as well as to present current MS Access capabilities, I can strongly recommend the following material, titled: "Comparison of Microsoft Access, LightSwitch and Visual Studio Platforms for Database Developers", written by Luke Chung, President and Founder of FMS, Inc. (software company since 1986, being involved in MS Access development since its beginnings).
Impressed? I am.