If within your organization you have a reasonably large Access population, the 2SQL MSO Inspector can be used to analyze network drives across your enterprise, auditing your Microsoft Access population to report detailed information on individual databases for conversion and/or decision-making.
Your Project Team can then apply its business judgment to assess each Microsoft Access Applications in terms of their size, importance and other factors to decide which of them should be converted, culled or simply left alone. The MSO Inspector predicts, with plus or minus 10% accuracy, the number of Conversion Issues that will need to be remedied, either manually or automatically, by the 2SQL Genie (a 2SQL program component used in a subsequent phase of the conversion project), to make each Application SQL Server-ready.
Using the Conversion Issue counts, along with other assessment criteria, your Project Team can “grade” the selected Microsoft Access Applications into one of 6 complexity ranges: Very Low, Low, Medium, High, Very High and Extreme.
The primary objective of performing the 2SQL MSO Inspector analysis is to narrow the project focus from what in some organizations can be an overwhelming Microsoft Access Application population running into the many thousands, down to what may be only the critical Applications representing between 2% and 5% of the whole population.
Your decision to convert all or part of your Access population can be made case-by-case, depending on resources, time and cost.