IT Solution and Installation Requirements
The NADABAS system is built as an Add-In for Microsoft Excel using Visual Basic for Applications (VBA), and its proper installation is crucial for optimal performance. Key technical requirements include:
Installation of Microsoft Office: A licensed version of Microsoft Excel 2013 or later is required to run NADABAS. Ensuring the correct installation of Excel, along with the appropriate settings, is a fundamental step since this assures users that NADABAS will function with future versions of both NADABAS and Microsoft Excel.
Database Setup: NADABAS supports both Microsoft Access and SQL Server Express as its database backend. IT teams should ensure that one of these databases is installed, configured, and properly linked to Excel.
System Environment: NADABAS runs exclusively on Windows, and it’s designed for deployment in both local (stand-alone) and networked (LAN) environments. For networked environments, ensuring the proper configuration of LAN, firewall settings, and user access controls is essential.
Multi-User Functionality: NADABAS can be installed in a multi-user environment where multiple stakeholders can access and share data. Administrators can manage user permissions and control access to files directly from the Excel ribbon, making the system ideal for team-based operations.
For optimal performance, it is recommended that IT teams follow best practices in software installation, system security, and user management. Regular updates and maintenance of both Excel and the database systems will ensure smooth operations and minimize technical issues.
Running NADABAS on a LAN
In many settings, National Accounts are compiled using multiple Excel workbooks. Without a system like NADABAS, managing these workbooks and their links can be prone to issues such as broken connections or version control challenges. NADABAS addresses these by using a database for central data storage and management, turning workbooks into a single, integrated system.
When running NADABAS on a Local Area Network (LAN), all the database and workbook files reside in a single base folder. This setup allows timestamped backups and version control. The system supports multiple users and includes administrative tools to control access to workbooks, making it ideal for teams working collaboratively.
In LAN setups, NADABAS accesses the database and workbooks for key tasks like opening files, loading data, and saving changes. Various configurations—from standalone setups to small wireless LANs or full centralized servers—can be tailored to different organizational environments. For larger implementations, SQL Server may be used to optimize performance.