ClusterSeven ADM (MS Access® Database Manager)

Print Version

ClusterSeven ADM uses the same architecture as ClusterSeven ESM (Enterprise Spreadsheet Manager) to deliver a central platform for the management of business-critical MS Access Databases. ADM may be integrated into ESM dashboards for unified control of end user computing.

  • ADM supports the complete database lifecycle:
  • Understanding your current state (eDiscovery and Risk Assessment)
  • Applying a control framework (Security, Monitoring and Alerting)
  • Enhanced productivity during your day-to-day operations
  • Database retirement and replacement with more robust systems

ADM tracks changes in the key structural attributes of the database including Queries, Tables, Reports, Forms and Links. Add in the ability to conduct ‘Ad Hoc’ comparisons and ADM delivers a powerful range of control and productivity opportunities including:

  • Central reporting and enforcement of best practices, including VBA code analysis, identification of ‘toxic SQL’ and poor query constructions
  • Identifying long running transactions and queries
  • Reporting and mapping of high risk links and data consumers
  • Safe deletion of database objects (e.g. tables) to shink files below the native file size limits of MS Access  (2GB in Access 2003/2007)
  • Identifying breaks in volatile data structures used in shared environments
  • Identifying broken schema models between multiple database versions e.g. spotting the differences in structure used with Daily Data and Monthly Data in separate databases
 

Working together, ClusterSeven ADM and ESM provide a complete solution to managing End User Computing applications (EUCs)

Print Version

"We were an early adopter of ClusterSeven's spreadsheet management product, so we naturally turned to ClusterSeven again in order to address our requirements for improving our control of other user-developed applications.

We worked together to define the requirements and ClusterSeven has delivered exactly what we needed."

Michael Cunningham, Head of Technology, European Credit Management (ClusterSeven client)

“By implementing a systematic tool you are no longer reliant on the users to put manual controls in place to flag up errors.”

Stephen Ashton, Head of IT business management, Dresdner Kleinwort (ClusterSeven client)