Error in conversion script 21 of IPS.MDB - Error in loading DLL

Problem:

When POS starts up on a new or existing install, the following error displays:

      

The following error is written to the IPSError.log (which can be for a array of different script numbers): 

Error running Conversion Script 21 converting IPS.MDB Line 182 : Error 48 : Error in loading DLL

Error running Conversion Script 63 converting IPS.MDB Line 0 : Error 48 : Error in loading DLL

Error running Conversion Script 64 converting IPS.MDB Line 0 : Error 48 : Error in loading DLL

Cause:

The registry is missing a valid path to the dao360.dll

Solution:

1. Start Regedit.

2. Go to \HKEY_CLASSES_ROOT\TYPELIB\{00025E01-0000-0000-C000-000000000046}\5.0\0\win32

Note:  If the key does not exist, manually create it and populate it with the correct information

3. Create or modify the key, using these values:

Name = (Default)

Type = REG_EXPAND_SZ

Value:

If 64-bit Windows and 32-bit Office

%CommonProgramFiles(x86)%\Microsoft Shared\DAO\dao360.dll

If 64-bit Windows and 64-bit Office, or 32-bit Windows and 32-bit Office:

%CommonProgramFiles%\Microsoft Shared\DAO\dao360.dll

Note that you could also use:

Type = REG_SZ

Value = (an absolute path to the DAO360.dll):

C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll