How to Use MS Access in a Strategic Manner in a Large Organization

In this article we look at using the Ms Access database in a large organization, often in conjunction with other database solutions.

Use MS Access In A Strategic Manner In A Large OrganizationAccess users often believe that it is an application ideal for small to midlevel organizations; for large organizations, high end applications like SQL Server or other enterprise grade databases should only be used. This statement is only partly correct. Access can also be used for large organizations, provided it is used in a strategic manner. You cannot simply install the application and then go on creating heavy databases in it, expecting it to support them. To be able to make full use of the application and implement it in large organizations you will first have to know all things important about Access, so that it puts you in a position to use the application strategically.

Why should you use MS Access?

Ms Access has a whole array of RDBMS features built into it despite being not appreciated as a true RDBMS.  Further its features have evolved over the years. Let look at some of key reasons you can choose to use Access in an enterprise

  1. The database challenges for all organizations keep on evolving, MS Access is one such application that can fight all these evolving challenges.
  2. The ROI offered by database solutions made in MS Access are tremendous, even if they are created at a departmental level.
  3. It is cost effective to enhance an already existing Access application than re-writing it.
  4. Not all solutions work well with expensive alternatives.

When Should you use MS Access?

Access is ideal for:

  1. For a ‘Good Enough’ prototyping.
  2. For solutions which justify cost and concept, before you proceed towards a more expensive solution.
  3. For creating customized database applications that can be deployed without the need of programmers

Using Access in Large organizations for Departmental Databases

Using Access In Large OrganizationsStrategically using Access in large organizations involves using it for creating multiple, small, departmental databases. If you are in a large organization and are required to operate large and heavy databases, MS Access will not be an ideal choice. However in a large organization, you also have the requirement of multiple departmental databases, which can be fulfilled by Access. SQL Server databases are way more expensive than Access databases, if you make use of Access databases for small databases, in one of the branches or departments of the organization, you can save a lot on the money and at the same time get all the important features. Further you can secure the data present in Access databases by investing in a repair Access utility. And if Access does not fulfill your requirements, you can always migrate to SQL Server.

Migrating from Access

  1. As mentioned already, when the number of users for your Access database increases, you can always begin using SQL Server instead of Jet, this will help you continue with the current performance.
  2. If there are any kind of problems arising within the Access application, take the help of skilled Access developers, to solve the problem and continue with Access.
  3. You can always convert an MDB to ADB. Or converting Access to Java, Visual Studio, Net MySQL, etc.

Author Introduction:

Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair SQL Server and excel recovery software products. For more information visit www.datanumen.com

2 responses to “How to Use MS Access in a Strategic Manner in a Large Organization”

  1. I made an almost 25 year career out of MS-Access with a little web development on the side. Most of my projects were department level or small to mid sized companies who needed an automated process built or who’s current process had outgrown papers, excel or word documents. No long, complicated expensive planning was required by the company. They would just call me in, few meetings to find out what they wanted, gather requirements and off I would go. Few weeks later I would come back with a solution. Of course inevitably there were always several rounds of changes and tweaks, but this was easy with MS-Access rapid development. The right tool in the right hands will work every time. I have seen other similar projects where months were spent planning, endless meetings consuming the salaried time of countless people, expensive hardware and software licenses purchased, etc…

  2. We used Access in UKM (University Library of Maribor) for Rapid Development of vital database design. With SSIS tools we put all the data into SQL Server. With SSRS we put the data to the users.