📘 Meridian Client – Resolving SQLCE 3.5 Requirement Notification
Overview:
When launching the Meridian Client, you may encounter a prompt or error indicating that Microsoft SQL Server Compact Edition (SQLCE) 3.5 is required. This is due to older configurations that used SQLCE for managing the Local Workspace database.
Meridian has since transitioned to using SQLite instead, which is more modern and requires no additional components—as long as the correct registry configuration is set.
🔍 Why This Happens:
Legacy Meridian setups used SQLCE to manage workspace data locally.
Newer versions of Meridian prefer SQLite, but without the proper registry key, the client defaults back to expecting SQLCE.
If the key isn’t set, users may see prompts to install SQLCE 3.5 unnecessarily.
✅ Resolution Steps:
To force Meridian to use SQLite instead of SQLCE, add or update the following registry key:
Registry Location Options:
Machine-wide (applies to all users):
HKEY_LOCAL_MACHINE\Software\Cyco\AutoManager Meridian\CurrentVersion\Client
Name: WorkspaceDB
Type: DWORD
Value: 8
User-specific (applies only to current user):
HKEY_CURRENT_USER\Software\Cyco\AutoManager Meridian\CurrentVersion\Client
Name: WorkspaceDB
Type: DWORD
Value: 8
💡 WorkspaceDB = 8 configures Meridian to use SQLite for Local Workspace management.
🛠️ Who Can Apply This Fix:
IT administrators can deploy this registry key via Group Policy or registry scripts.
Advanced users with admin permissions can apply it manually using regedit.