"Access denied" after Windows Update on server

Some users might get this error message when they are updating a database from .MDB to .SDF. In this scenario, it is not possible to create, add, or change values in the tables in the Configurator, nor to restart the EDM service after changing UserDBSqlCeProvider from Microsoft.SQLSERVER.CE.OLEDB.3.5 to Microsoft.SQLSERVER.CE.OLEDB.4.0.

To fix this issue:

1. Convert .MDB to .SDF.

2. To upgrade .SDF to CE.4.0, UserDB.sdf should be explicitly upgraded from 3.5 to 4.0 with the BlueCieloECM.SdfUpdate utility.

3. Configure the following values in this registry key:

   HKEY_LOCAL_MACHINE\SOFTWARE\Cyco\AutoManager Meridian\CurrentVersion\Server\UserDatabase

   1. Set ConnectionString to [Path]\ICUserDB.SDF.

   2. Set UserDBSqlCeProvider to Microsoft.SQLSERVER.CE.OLEDB.4.0.

4. Configure the following values in this registry key:

   HKEY_LOCAL_MACHINE\SOFTWARE\Cyco\AutoManager Meridian\CurrentVersion\Server

   1. Set TablesDB to dword:00000001.

   2. Set TablesDBSqlCeProvider to Microsoft.SQLSERVER.CE.OLEDB.4.0.

5. Open a command window (CMD) and register BlueCieloECM.UIBehNet40.dll using the following information:

   C:\Windows\Microsoft.NET\Framework\v4.0.30319\regasm.exe "C:\Program Files\BC-Meridian\Program\BlueCieloECM.UIBehNET40.dll" /codebase /nologo

   C:\Windows\Microsoft.NET\Framework64\v4.0.30319\regasm.exe "C:\Program Files\BC-Meridian\Program\BlueCieloECM.UIBehNET40.dll" /codebase /nologo