Five Reasons to Upgrade CloudNine LAW Case Management from Access to SQL
Originally, CloudNine LAW managed case information using the caselist.mdb file, typically stored in the LAW executable directory. To add a case to the Open Case/Case Management window, users had to browse to the case directory and select the project.ini file, which would then update the local caselist.mdb.
As CloudNine LAW evolved, case management transitioned to a SQL backend for enhanced performance, security, and scalability.
If you are still using the caselist.mdb (Access) for case management in CloudNine LAW, it's time to upgrade to a SQL backend. Here are five compelling reasons to make the switch.
1. Access Not Supported (LAW 7.7108 and up)
Support for Access versions of LAW's Case Management Databases ended with CloudNine LAW 7.7108 and has not been available for the last six versions. Without support, you risk compatibility issues, performance degradation, and a lack of technical assistance. Upgrading to SQL ensures your system remains functional, secure, and prepared for future enhancements.
2. Enhanced Security with SQL
SQL databases provide enhanced security for sensitive client data through advanced user permissions, encryption, and logging capabilities—features that are absent in Access. Transitioning to SQL safeguards against data breaches, unauthorized access, and compliance risks.
3. Reduced Risk of Data Corruption
Access databases are prone to corruption, particularly in multi-user settings. In contrast, SQL databases offer greater stability and reliability, reducing downtime and data loss for a more dependable case management experience.
4. Cloud Accessibility
SQL databases can be hosted in the cloud, enabling remote access, simplified backups, and enhanced collaboration across offices. This flexibility is essential as organizations increasingly adopt hybrid working models, allowing secure access to case data from anywhere.
5. Scalability and Performance
Access databases are limited to 2GB in size. This can be a serious bottleneck as you grow and case files accumulate. SQL databases are not capped (beyond available storage) and support features like distributed batch processing for faster data handling.
Final Thoughts
Upgrading LAW's Case Management database to SQL is a strategic move that enhances security, scalability, and support, enabling your organization to serve clients better, manage cases efficiently, and adapt to future legal technology.
References
CloudNine LAW Answer Center: Configuration Utility
Contact LAW Support: lawsupport@cloudnine.com